access_time 7 months ago languageEnglish
more_vert

Check User Access on Teradata

visibility 45 comment 0

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
copyright This page is subject to Site terms.
Like this article?
Share on

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts

Follow Kontext

Get our latest updates on LinkedIn.

Want to contribute on Kontext to help others?

Learn more

More from Kontext

visibility 1962
thumb_up 0
access_time 11 months ago
visibility 1388
thumb_up 0
access_time 11 months ago