Want to establish roles (a ROLE), and authorization can update all the tables, but some form cannot update, how should do?
I set up a ROLE in PLSQL, system permissions to select any table and update any table, but want to use REVOKE to recycle a table update permissions will be prompted to "" "ORA - 01927, cannot REVOKE you do not have permission to GRANT ", strange, I'm not gave any table permissions?
Please directly, thank you!
CodePudding user response:
A form to authorize,CodePudding user response:
More than 3000 tables...There is no other way?
CodePudding user response:
- dynamic statement
Select 'grant select on' | | table_name | | 'to new_user; 'the from user_tables
Where table_name not in (' A ', 'B', 'C') - excluding watch
CodePudding user response:
To solve the problem, thank you!CodePudding user response:
Through a role permissions can't take back alone, in addition to the unlimited in tablespace