All Forums Database
p2mcdon1 1 post Joined 01/14
23 Sep 2015
Checking Table Access Rights for Users Connected via LDAP

I was wondering if there was a query to enumerate all the databases/tables to which I have access, given I have logged on via LDAP.  The results of querying the X Views, such as dbc.DatabasesVX and dbc.TablesVX do not show all of the databases and tables I have access to, so it would seem a more complex solution would be required.
Any help on this would be greatly appreciated!

gskaushik 56 posts Joined 09/10
26 Sep 2015

Hi p2mcdon1
All the users are recorded within DBC.USERS
If you want to understand what are the role asssigned you can use DBC.Rolemembers
All the access rights for a role is avaialble in DBC.Allrolerights
Note :- Accesstype would be a two letter word need to refer to manual for complete descripiton.
If you have assigned the rights directly to an user then refer to DBC.Accessrights

Subramanian kaushik Gurumoorthy

You must sign in to leave a comment.