The following SELECT statement displays information about all tables in the Personnel database on which privileges were granted to the requesting user.
SELECT * FROM DBC.UserRightsV WHERE DatabaseName=’Personnel’ AND TableName = ’All’ ;
Result:
DatabaseName TableName AccessRight GrantorName ------------ --------- ----------- ----------- Personnel Employee R DBC Personnel Employee U DBC Personnel Employee I DBC