Archives of the TeradataForum
Message Posted: Tue, 05 Mar 2013 @ 16:43:53 GMT
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!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|