The following SELECT statement displays the privileges user Jones has on tables:
SELECT Tablename, AccessRight, GrantorName FROM DBC.AllRightsV WHERE UserName = ’Jones’;
Result:
TableName AccessRight GrantorName ---------- ----------- ------------- project RS SYSTEMAD project DP SYSTEMAD project DT SYSTEMAD project D SYSTEMAD project I SYSTEMAD project U SYSTEMAD project R SYSTEMAD employee I SYSTEMAD employee U SYSTEMAD