How do I check what all permession a user is having?
Moderator: NorbertKrupa
How do I check what all permession a user is having?
How do I check that how is the user account set up?? Also what all permission and access a particular user have??
-
JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: How do I check what all permession a user is having?
Check the V_CATALOG.GRANTS tables!
Example:
SELECT * FROM v_catalog.grants WHERE grantee = <<user>>;
Example:
SELECT * FROM v_catalog.grants WHERE grantee = <<user>>;
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.