Monday, April 20, 2015

List users based on role

SELECT grantee FROM DBA_ROLE_PRIVS
 WHERE GRANTED_ROLE = 'HMA_TM_PROD_RO_ROLE';

No comments:

Post a Comment

Featured Post

Apply Patch 22191577 latest GI PSU to RAC and DB homes using Opatch auto or manual steps

Patch 22191577: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.160119 (JAN2016) Unzip the patch 22191577 Unzip latest Opatch Version in or...