To know roll access

Analytics
MDF
N/A

To know roll access

Hi,

I m new to teradata.
I don't have access on DBC. Can anyone tell me, how come i will know which are the database have given me the access in Teradata.

Thanks
1 REPLY
Enthusiast

Re: To know roll access

UserRights will give you all the objects/rights to which you explicitly have access.
UserRoleRights gives you all the objects to which you have access via a role.

So you can just union these views.
A couple of points - rights can be given below database level, so you could have rights to some tables in a database but not others.
2. If your default role is not ALL, you could have rights to an object through a role but may not be able to exercise those rights while working in a different role.

HTH