teradata

Check User Access on Teradata

event 2021-01-19 visibility 2,136

more_vert

The following code snippet checks user DBC's access on all Teradata objects incl. tables, views. procedures, functions, etc.

select * from dbc.allrights
where UserName ='DBC';

Sample output:

To check current user's access on database objects in Teradata, use the following query:

select * from dbc.allrights
where UserName = current_user;

Alternatively, use view DBC.UserRightsV:

select * from DBC.UserRightsV;

Sample output:

copyright This page is subject to Site terms.

Teradata