Create user: default tablespace, temporary tablespace, quota : Create User « User Previliege « Oracle PL / SQL






  1. Oracle PL / SQL
  2. User Previliege
  3. Create User

Create user: default tablespace, temporary tablespace, quota

 

SQL>
SQL> create user aNewUser
  2      identified by doomed
  3      default tablespace users
  4      temporary tablespace temp
  5      quota unlimited on users;

User created.

SQL>
SQL>
SQL> grant create session, create table to aNewUser;

Grant succeeded.

SQL>
SQL> connect aNewUser/doomed;
Connected.
SQL>
SQL> create table employees_backup (
  2        employee_id number,
  3        last_name   varchar2(30),
  4        email       varchar2(100)
  5      );

Table created.

SQL>
SQL> drop table employees_backup;

Table dropped.

SQL>








Related examples in the same category

1.Create User demo
2.Create user and assign password
3.Create a user and drop it