DBC View for privileges for all users?

Database
Enthusiast

DBC View for privileges for all users?

Currently when I run a SELECT against DBC.UserRoleRights it only brings back results for my user. Is there a view or a way to see the same result of UserRoleRights but for all users?
4 REPLIES
Junior Contributor

Re: DBC View for privileges for all users?

dbc.AllRoleRightsV :-)

Dieter
Enthusiast

Re: DBC View for privileges for all users?

I may not have explained as well as I could have.

So when doing a sel * from dbc.userrolerights I receive a list of every rolename / databasename / tablename / columnname / accessright / grantorname for my user. I want to have this same information but for every user on the system. AllRoleRightsV doesn't have a username column so I am not sure how it could provide this detail. I thought maybe it would list the users under the databasename tab but then it would just 1 record per username which is not correct.

As always -- thanks for the quick response Dieter.
Junior Contributor

Re: DBC View for privileges for all users?

Ok, why don't you join it to dbc.RoleMembersV?

Dieter
Enthusiast

Re: DBC View for privileges for all users?

Perfect, thank you.