How to create a new user account in oracle?



How to create a new user account in oracle?..

Answer / Nitin Jeet Kumar

To create a new user account in Oracle, you can use the `CREATE USER` command. Here's an example:

```sql
CREATE USER new_user IDENTIFIED BY your_password;
```
Replace `new_user` with the desired username and `your_password` with the desired password.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle General Interview Questions

What are the basic element of Base configuration of an oracle Database ?

2 Answers  


hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4

1 Answers   CTS,


In the oracle version 9.3.0.5.0, what does each number shows?

1 Answers  


How can you Enforce Referential Integrity in snapshots ?

1 Answers  


Can we protect our pl/sql source code?

1 Answers  


Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks

2 Answers   IBM,


what diffrence between function and procedure?

4 Answers  


what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?

1 Answers   Arrow Electronics,


What is execute immediate in oracle?

1 Answers  


How to invoke the original export import utilities?

1 Answers  


What is a data lock in oracle?

1 Answers  


Difference between pre-select and pre-query

1 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)