sys_privilege & object_privilege

常用系统权限
分组1：
   1、Create Session
   2、Unlimited Tablespace
   3、Alter System
   4、Alter Database
分组2：
   1、Create Sequence
   2、Create Type 
   3、Create Table
   4、Create View
   5、Create Synonym 
   6、Create Procedure
   7、Create Trigger
   8、Create Role;
   9、Create Public Synonym | Drop Public Synonym 
   10、Create Profile | Alter Profile |Drop Profile
   11、Create User | Alter User| Drop User
   12、Create Tablespace | Alter Tablespace | Drop Tablespace
   
分组3：
   1、Create Any Type | Drop Any Type
   2、Create Any Sequence | Alter Any Sequence | Drop Any Sequence | Select Any Sequence 
   3、Create Any Table | Alter Any Table | Drop Any Table | Select Any Table | Insert Any Table | Delete Any Table 
   4、Create Any View | Drop Any View
   5、Create Any Synonym | Drop Any Synonym 
   6、Create Any Procedure | Drop Any Procedure | Execute Any Procedure 
   7、Create Any Trigger | Drop Any Trigger
   8、Create Any Directory |  Drop Any Directory
   9、Select Any Dictionary


授权:
     grant sys_privilege to user_name | public | role with admin option;
收回:
     revoke sys_privilege from user_name | public | role;
权限可传递，不级联收回




对象权限
  grant all|select|insert|update[(列名)]|delete|execute on [schema.]object_name to user_name | public | role 
  with grant option;
  revoke all|select|insert|update[(列名)]|delete|execute on [schema.]object_name from user_name | public | role  ;
权限可传递，级联收回