Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center