Comments for Capture Privilege Usage (DBMS_PRIVILEGE_CAPTURE) in Oracle Database 12c Release 1 (12.1)
Ronan said...Hi Tim,
CUSTOM_ROLE (or the user) needs tablespace privileges too.
When you run the DDL again after the revoke, you get ora-01950: no privileges on tablespace
Will said...Use of this package requires the purchase of the Database Vault license.
Do not run this package unless you are sure of your license agreement with Oracle.
I've added the warning. Just in case.
DO NOT ask technical questions here! They will be deleted!
These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!
If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.