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!
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