Mega Code Archive

 

Categories / Oracle PLSQL / User Previliege

 

Create user

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>