–分为系统权限和对象权限,系统权限收回不是联级的,对象权限收回是联级的(with grant option)
–=系统权限===
–查询所有用户
select u.username,u.default_tablespace,u.account_status,u.profile from dba_users u
–查询dog用户的所有权限
select * from dba_sys_privs p where p.grantee = ‘DOG’;
–授予系统权限
grant create session,select any table,create table to dog;
–谨慎使用,加上with admin option后,该用户可以把这些权限赋予其他用户,就控制不住权限了;
grant create session,select any table,create table to dog with admin option;
–收回权限
revoke create session,select any table,create table from dog;