User add and adding Privileges

User add and adding Privileges

SQL> create tablespace test datafile '/Oracle/ora/TEST/Data/proddata/test.dbf'size 1000m

SQL> create user test identified by test

SQL> alter user test default tablespace test

SQL> alter user test quota unlimited on test

SQL> grant connect to test

SQL> grant create session to test

SQL> grant create table to test

 
(INCASE IF GIVING GRANT ON ANY PACKAGE OR PROCEDURE)

SQL> grant execute, debug on <PACKAGE / PROCEDURE NAME > to test

SQL> grant select on dba_source to test

SQL> grant select on dba_objects to test

SQL> grant select any table to test


FOR TESTING OF CREATE DROP

SQL> conn test/test
Connected.

SQL> create table testing (col1 varchar2(5));
Table created.

SQL> alter table testing add (col2 varchar2(5));
Table altered.

SQL> drop table testing;
Table dropped.