Creating a User : Create User « User Privilege « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. User Privilege
  3. Create 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

  1. If you omit a default tablespace, the default SYSTEM tablespace is used.
  2. Tablespaces are used by the database to separate objects.
  3. temp_tablespace specifies the default tablespace where temporary objects are stored.
  4. If you omit a temporary tablespace, the default SYSTEM tablespace is used.








36.1.Create User
36.1.1.Creating a User
36.1.2.Create user and assign password
36.1.3.Creates a user named jason with a password of pass
36.1.4.Create user with storage quota
36.1.5.User space
36.1.6.Creates a user named henry and specifies a default and temporary tablespace
36.1.7.Create User Utility
36.1.8.create user with temporary tablespace, quota and default tablespace
36.1.9.Display current user
36.1.10.Alter user to change the password