How to extract the ddl for all application role grants in a schema (11.2.0.4)
Here is an example of an application role used by the application:
CREATE ROLE "ASSESS_CREATE" NOT IDENTIFIED;
These application roles are granted system and object privileges.
I need to extract the system and object privileges that were granted to these application roles.
I am planning the migration of Oracle application data from 11.2.0.4 to 12.2.0.1 using DP Export/Import.
Thanks & Regards,
D.W.