access_time 4 months ago languageEnglish
more_vert

Check Role Access on Tables/Views in Teradata

visibility 72 comment 0

Check role's access on Teradata table/view

The following code snippet checks all roles with access on certain Teradata table or view. 

select * from dbc.allrolerights
where databasename='TestDb'
and tablename = 'test_table';

Sample output:


Check role's access on all objects

To check certain role's access on database object in Teradata, use the following query:

select * from dbc.allrolerights
where rolename='TestRole';

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
info Last modified by Raymond 4 months ago 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 4658
thumb_up 1
access_time 2 years ago
visibility 31
thumb_up 0
access_time 4 months ago
visibility 890
thumb_up 0
access_time 2 years ago
visibility 967
thumb_up 0
access_time 9 months ago
visibility 284
thumb_up 0
access_time 9 months ago