以下のSELECT文は、データベースDBAの詳細を返します。
SELECT * FROM AuthorizationsV WHERE databasename = 'dba';
結果:
DatabaseName dba AuthorizationName INVOKER_DEFAULT AuthorizationId 00001F0A0000 TableKind X Version 1 AuthorizationType I AuthorizationSubType D OSDomainName OSUserName gdUsrGrp DatabaseName dba AuthorizationName myinvoker AuthorizationId 00001E0A0000 TableKind X Version 1 AuthorizationType I AuthorizationSubType D OSDomainName OSUserName gdUsrGrp