Skip to Content

EFFECTIVE PRIVILEGES OR ROLES AND GRANTEE FOR A USER

Hi All,

When I run the query SELECT * FROM "PUBLIC"."EFFECTIVE_ROLES" WHERE USER_NAME = 'USER1', I get the list of all roles, assigned. But a repository role, created by another user(say USER2) still shows as GRANTEE as USER1. I think it should have been USER2, since the repository role was created and assigned by USER2

Regards

Plaban

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers