oracle常用操作指令

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;//调试存储过程权限