Oracle Common Operations Directives

1.cmd Sqlplus/nolog;

2.conn Sys/as sysdba;

3.Create user query identified by query;//

4.alter user Query Account unlock;//unlocked

5.alter user query identified by tiger;//change password

6.grant Connect,resource to query;//permissions

7.select t.* from tab t;//View all tables

7. (1) Grant Select,insert,delete,update on scott.emp to query;

(2) Grant select,insert,delete,update any table to query;

8. (1) Revoke Delete,update,insert on scott.emp from query;//reclaim permissions

(2) Revoke update any table from query;

9. Grant Debug Connect Session,debug any procedure to scott;//Debug stored procedure permissions

Oracle Common Operations Directives