Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

suppress privilege in built-in Oracle Database Role

Emad Al-MousaDec 15 2019

it will be great if Oracle can provide the capability to suppress a certain privilege within a database built-in role. For example, if a database account has been granted the DBA role....i would like revoke/deny from it the capability of create any user privilege.

SQL> grant DBA to user1;

SQL> revoke/deny create any user from user1;

so user1 will have all privileges granted under DBA role except "creating any user".

Regards,

Emad Al-Mousa

Comments
Post Details
Added on Dec 15 2019
6 comments
111 views