Archives of the TeradataForum

Message Posted: Wed, 20 Feb 2002 @ 20:41:17 GMT

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

This is the SQL generated by Winddi for Rights held by user/database:

SELECT
DatabaseName
,TableName
,ColumnName
,AccessRight
,GrantAuthority
,GrantorName
,AllnessFlag
FROM dbc.AllRights
WHERE UserName=?
ORDER BY 1,2,3,4

This is for rights held on user/database:

SELECT
UserName
,AccessRight
,GrantAuthority
,GrantorName
,AllnessFlag
FROM dbc.AllRights
WHERE DatabaseName=?
AND TableName='All'
ORDER BY 1,2

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