ora14-用户权限.pptVIP

查询权限分配情况 数据字典 select table_name from user_tables select view_name from user_views; select index_name,table_name from user_indexes select sequence_name,min_value,max_value,increment_by from user_sequences select synonym_name,table_name from user_synonyms select username,user_id from user_users select * from user_sys_privs; select username,granted_role from user_role_privs select * from role_sys_privs; select uid from dual; 使用 REVOKE 语句收回权限 使用 WITH GRANT OPTION 子句所分配的权限同样被收回 REVOKE {privilege [, privilege...]|ALL} ON object FROM {user[, user...]|role|PUBLIC} [CASCADE CONSTRAINTS]; 收回对象权限