1.cmd sqlplus /nolog;
2.conn sys/ as sysdba;
3.create user query identified by query;//创建用户
4.alter user query account unlock;//解锁
5.alter user query identified by tiger;//修改密码
6.grant connect,resource to query;//赋权限
7.select t.* from tab t ;//查看所有的表
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;//回收权限
(2) revoke update any table from query;
9. grant debug connect session,debug any procedure to scott;//调试存储过程权限