Archives of the TeradataForum
Message Posted: Fri, 08 Apr 2005 @ 08:16:16 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|