Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


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

Hi,

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>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016