1.

Give The Statement To Create A User?

Answer»

SQL>CREATE USER (username) IDENTIFIED BY (password);
In case of ORACLE DATABASE 11g use the following statement:
SQL>CREATE USER (username) identified by "(password)";
The above query creates a user and password for the user. It is good practice to assign default temporary and permanent tablespace to the users. It is a good practice to ass them at the time of database creation.

SQL>CREATE USER (username) IDENTIFIED BY (password);
In case of Oracle database 11g use the following statement:
SQL>CREATE USER (username) identified by "(password)";
The above query creates a user and password for the user. It is good practice to assign default temporary and permanent tablespace to the users. It is a good practice to ass them at the time of database creation.


Discussion

No Comment Found

Related InterviewSolutions