Database Administration (MOSC)

MOSC Banner

How to grant SELECT on SYS.USER$ to application user in ATP-S Database ?

Does anyone knows how we can grant SELECT privilege's on SYS.USER$ table to an application user ?

ADMIN (super user in ATP) does not have privilege's to select/grant it to application user.

I was able to find a workaround for another table (SYSAUTH$) via role DV_SECANALYST but I could not find any role that has USER$ table SELECT privileges .

Kindly assist , customer would need the same to run their application code.


Thanks,

Arpit

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