次のSELECT文は、ユーザーの現在のロールと現在のロールにネストされたロールに付与されたすべての権限を返します。
SELECT CAST(RoleName as CHAR(16)) as RoleName, CAST(DatabaseName as CHAR(15)) as Databases, CAST(TableName as CHAR(15)) as TVMs, CAST(ColumnName as CHAR(10)) as Columns, CAST(AccessRight as CHAR(5)) as AccRights, CAST(GrantorName as CHAR(15)) as Grantor FROM DBC.UserRoleRightsV ORDER BY 1,2,3,5;
結果:
RoleName Databases TVMs AccRights Grantor -------------- --------------- --------------- --------- --------- roles017_r1f roles017_3_db roles017_3_v2 R roles017_3 roles017_r2d roles017_3_db roles017_3_v2 R roles017_3