Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_METADATA.GET_GRANTED_DDL TO TRACK ROLES AND PRIVILEGES

JhilSep 10 2018 — edited Sep 10 2018

Dear all,

When we do schema refresh from one database to another,

what is the best approach to get complete information of roles and  profiles for a specific user ?

>> Is this enough ?

SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT',SCHEMA_NAME') from dual;

SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','SCHEMA_NAME) from dual;

db 11204  & 12102
This post has been answered by Mark D Powell on Sep 10 2018
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 8 2018
Added on Sep 10 2018
#general-database-discussions
7 comments
5,911 views