Find role and associated priveleges with it.

Database

Find role and associated priveleges with it.

Hi All,

I'm new to Teradata coming  from Oracle....I wanted to know how can I find the privileges and type of privileges granted to roles....I have been searching for Data dictionary view to pull of this information but noluck yet..

I'm going to use this for creating some security reports....

Looking for something like this....

Role_name  Owner Object_name Privileges

ABC               XYZ      tbs_xyz        Delete/update/Insert/execute

Thanks

2 REPLIES
Enthusiast

Re: Find role and associated priveleges with it.

Hi ,

You can get all the information in dbc.allrolerightsv

RoleName

DatabaseName

TableName

ColumnName

AccessRight

GrantorName

CreateTimeStamp

Regards,

Praveen.




Re: Find role and associated priveleges with it.

Thanks Praveen