Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / User Privilege

 

Creating a User

To create a user in the database, you use the CREATE USER statement. The simplified syntax for the CREATE USER statement is as follows: CREATE USER user_name IDENTIFIED BY password [DEFAULT TABLESPACE default_tablespace] [TEMPORARY TABLESPACE temp_tablespace]; where If you omit a default tablespace, the default SYSTEM tablespace is used. Tablespaces are used by the database to separate objects. temp_tablespace specifies the default tablespace where temporary objects are stored. If you omit a temporary tablespace, the default SYSTEM tablespace is used.