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