Check User Access on Teradata

Check user's access on Teradata

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:

Check current user's access

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:

Reference

Useful DBC (Data Base Computer) System Views in Teradata

Access rights code

• AE - Alter External Procedure
• AF - Alter Function
• AP - Alter Procedure
• AS - Abort Session
• CA - Create Authorization
• CD - Create Database
• CE - Create External Procedure
• CF - Create Function
• CG - Create Trigger
• CM - Create Macro
• CO - Create Profile
• CP - Checkpoint
• CR - Create Role
• CT - Create Table
• CU - Create User
• CV - Create View
• D - Delete
• DA - Drop Authorization
• DD - Drop Database
• DF - Drop Function
• DG - Drop Trigger
• DM - Drop Macro
• DO - Drop Profile
• DP - Dump
• DR - Drop Role
• DT - Drop Table
• DU - Drop User
• DV - Drop View
• E - Execute
• EF - Execute Function
• GC - Create GLOP SET
• GD - Drop GLOP SET
• GM - GLOP Member
• I - Insert
• IX - Indexes
• MR - Monitor Resource
• MS - Monitor Session
• NT - Non Temporal
• OA - Override Archive Constraint
• OD - Override Delete Constraint
• OI - Override Insert Constraint
• OP - Create Owner Procedure
• OR - Override Restore Constraint
• OS - Override Select Constraint
• OU - Override Update Constraint
• PC - Create Procedure
• PD - Drop Procedure
• PE - Execute Procedure
• R - Retrieve or Select
• RF - References
• RS - Restore
• SH - Show
• SA - Constraint Assignment
• SD - Constraint Definition
• SS - Set Session Rate
• SR - Set Resource Rate
• ST - Statistics
• TH - Connect Through
• U - Update
• UM - UDT Method
• UT - UDT Type
• UU - UDT Usage