Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 05 Mar 2013 @ 16:43:53 GMT

  <Prev Next>  
Next> Last>>  

Subj:   How to identify database privieges for selected users
From:   DUELL, BOB


We have a very large Teradata system with thousands or users, about 200 of which I support. I'd like to create a report the shows the permissions my users have on various databases.

I found a view named DBC.UserRoleRights that shows all privileges for my own ID and can see from the view definition how "roles" are restricted in the "where" clause.

Before digging deeper, I'd like to ask if anyone has a query that will report the same columns as DBC.UserRoleRights for a list of specific users.

Also, I'm particularly interested in "database level" permissions, not privileges granted to individual tables.

Hope this is clear; thanks in advance!

Bob Duell
Manager, Systems and Integration
AT&T Mobility; CLM Database Marketing

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020