The following views list privileges: • DBC.AllRightsV • DBC.UserGrantedRightsV • DBC.UserRightsV • DBC.RoleMembersV • DBC.AllRoleRightsV • DBC.UserRoleRightsV
DBC.AllRightsV The DBC.AllRightsV view gives the access rights for all user on the system. The column names are: UserName, DatabaseName, TableName, FieldName, AccessRight, WithGrantOption, GrantorName and AllnessFlag.
SELECT * FROM dbc.allrightsV WHERE username = 'myuser';
• DBC.UserGrantedRightsV The DBC.UserGrantedRightsV view provides information on access rights that the current user has granted to other users. The column names are: DatabaseName, TableName, FieldName, Grantee, AccessRight, WithGrant and AllnessFlag.
SELECT * FROM dbc.UserGrantedRightsV; • DBC.UserRightsV The DBC.UserRightsV view gives the access rights that have been granted to the current user. The column names are: DatabaseName, TableName, FieldName, AccessRight, WithGrant and GrantorName SELECT * FROM dbc.UserRightsV;
• DBC.RoleMembersV The RoleMembersV view provides information about members of roles. The column names are: RoleName, Grantee, GranteeKind, Grantor, WhenGranted, DefaultRole and WithAdmin. SELECT * from DBC.ROLEMEMBERSV where Grantee='myuser';
• DBC.AllRoleRightsV The AllRoleRightsV view provides information about the rights granted to each role. The column names are: UserName, DatabaseName, TableName, ColumnName, AccessRight, GrantAuthority, GrantorName and CreateTimeStamp.
SELECT * from DBC.ALLROLERIGHTSV where role name in (SELECT rolename from DBC.ROLEMEMBERS where Grantee='myuser') order by role name;
• DBC.UserRoleRightsV The UserRoleRightsV view provides a list of rights granted to the current role of the user and its nested roles. The columns names are: RoleName, DatabaseName, TableName, ColumnName, AccessRight, GrantorName and CreateTimeStamp.
Select * From dbc.UserRoleRightsV;
Privilege Abbreviations in System Views •AE = ALTER EXTERNAL PROCEDURE •AF = ALTER FUNCTION •AP = ALTER PROCEDURE •AS = ABORT SESSION •CA = CREATE AUTHORIZATION •CD = CREATE DATABASE •CE = CREATE EXTERNAL PROCEDURE •CF = CREATE FUNCTION •CG = CREATE TRIGGER •CM = CREATE MACRO •CO = CREATE PROFILE •CP = CHECKPOINT •CR = CREATE ROLE •CS = CREATE SERVER •CT = CREATE TABLE •CU = CREATE USER •CV = CREATE VIEW •CZ = CREATE ZONE •D = DELETE •DA = DROP AUTHORIZATION •DD = DROP DATABASE •DF = DROP FUNCTION •DG = DROP TRIGGER •DM = DROP MACRO •DO = DROP PROFILE •DP = DUMP •DR = DROP ROLE •DS = DROP SERVER •DT = DROP TABLE •DU = DROP USER •DV = DROP VIEW •DZ = DROP ZONE •E = EXECUTE •EF = EXECUTE FUNCTION •GC = CREATE GLOP •GD = DROP GLOP •GM = GLOP MEMBER •I = INSERT •IX = INDEX •MR = MONITOR RESOURCE •MS = MONITOR SESSION •NT = NONTEMPORAL •OA = OVERRIDE DUMP CONSTRAINT •OD = OVERRIDE DELETE CONSTRAINT •OI = OVERRIDE INSERT CONSTRAINT •OP = CREATE OWNER PROCEDURE •OR= OVERRIDE RESTORE CONSTRAINT •OS = OVERRIDE SELECT CONSTRAINT •OU = OVERRIDE UPDATE CONSTRAINT •PC = CREATE PROCEDURE •PD = DROP PROCEDURE •PE = EXECUTE PROCEDURE •R = RETRIEVE/SELECT •RF = REFERENCES •RS = RESTORE •SA = CONSTRAINT ASSIGNMENT •SD = CONSTRAINT DEFINITION •SH = SHOW •SR = SET RESOURCE RATE •SS = SET SESSION RATE •ST = STATISTICS •TH = CTCONTROL •U = UPDATE •UM = UDT METHOD •UT = UDT TYPE •UU = UDT USAGE •ZO = ZONE OVERRIDE |