Archives of the TeradataForum

Message Posted: Fri, 08 Apr 2005 @ 08:16:16 GMT

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

hi

i have one query

i m using teradata 5.0

if i m writing the query

     grant 'priveleges' to  'user name'

----- priveleges = "create user" or "drop user" .....

so in which Systems Table or System Views i can i find this data ?

i want data related only user and which grant

i don't want any data related to database.table or database with which grant...

so which query i fire so i can get data related only user and which grant ? this must be unique...(username and grant)

Thanks in Advance

Maheshwari Rajesh

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