第三天3-3

select * from tabselect * from dba_usersselect * from dba_tables where owner='TEST'select * from test.tdesc v$session --sql commandselect distinct sid from v$mystatselect username,schemaname from v$session where sid=145;alter session set current_schema=test1;SQL> select username,schemaname from v$session where sid=144;USERNAME                       SCHEMANAME------------------------------ ------------------------------SYS                            TESTselect * from t --t前面就不用再加schema了exp helpexpdp help =yselect * from dba_sys_privs where grantee='TEST'select * from system_privilege_mapselect * from dba_role_privsselect * from dba_rolesgrant RESOURCE to testSQL> create trigger trigger_test --ddl触发器  2  after ddl on test1.schema  3  declare  4  ....;  5  end;  6  /  alter trigger trigger_test disable;  create sequence seq1;  SQL> create sequence seq2  2  start with 100  3  increment by 10  4  maxvalue 200  5  cycle  6  nocache  7  /