Skip to Content
0

EFFECTIVE PRIVILEGES OR ROLES AND GRANTEE FOR A USER

Aug 19, 2017 at 01:41 AM

90

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers