Check User Access on Teradata

event 2021-01-19 visibility 2,029 comment 0 insights
more_vert
insights Stats
Raymond Raymond Teradata

Tutorials and information about 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:

20210119115631-image.png

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:

20210119115631-image.png

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
More from Kontext
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts