create user with temporary tablespace, quota and default tablespace : Create User « User Privilege « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. User Privilege
  3. Create User
SQL> create user dropme
  2      identified by pass
  3      default tablespace users
  4      temporary tablespace temp
  5      quota unlimited on users;

User created.

SQL>
SQL> grant create session, create table
  2      to dropme;

Grant succeeded.

SQL>
SQL>
SQL>
SQL> --drop user dropme;
SQL> drop user dropme cascade;

User dropped.

SQL>
SQL>








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