Archives of the TeradataForum

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

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

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>>