InterBase - статьи


Пользователи - часть 2


Вот так можно посмотреть, какие привилегии даны триггерам.

SELECT RDB$USER_PRIVILEGES.RDB$USER, RDB$USER_PRIVILEGES.RDB$GRANTOR, RDB$USER_PRIVILEGES.RDB$PRIVILEGE, RDB$USER_PRIVILEGES.RDB$GRANT_OPTION, RDB$USER_PRIVILEGES.RDB$RELATION_NAME, RDB$USER_PRIVILEGES.RDB$FIELD_NAME, RDB$TYPES.RDB$TYPE_NAME, RDB$TYPES1.RDB$TYPE_NAME FROM RDB$USER_PRIVILEGES INNER JOIN RDB$TYPES ON (RDB$USER_PRIVILEGES.RDB$USER_TYPE = RDB$TYPES.RDB$TYPE) INNER JOIN RDB$TYPES RDB$TYPES1 ON (RDB$USER_PRIVILEGES.RDB$OBJECT_TYPE = RDB$TYPES1.RDB$TYPE) WHERE ((RDB$TYPES.RDB$FIELD_NAME = 'RDB$OBJECT_TYPE') and (RDB$TYPES1.RDB$FIELD_NAME = 'RDB$OBJECT_TYPE') and (RDB$TYPES.RDB$TYPE_NAME = 'TRIGGER')) ORDER BY RDB$USER_PRIVILEGES.RDB$USER;

Следующий запрос показывает, привилегии каких ролей каким пользователям выданы.

SELECT RDB$USER_PRIVILEGES.RDB$USER, RDB$USER_PRIVILEGES.RDB$GRANTOR, RDB$USER_PRIVILEGES.RDB$PRIVILEGE, RDB$USER_PRIVILEGES.RDB$GRANT_OPTION, RDB$USER_PRIVILEGES.RDB$RELATION_NAME, RDB$USER_PRIVILEGES.RDB$FIELD_NAME, RDB$TYPES.RDB$TYPE_NAME, RDB$TYPES1.RDB$TYPE_NAME FROM RDB$USER_PRIVILEGES INNER JOIN RDB$TYPES ON (RDB$USER_PRIVILEGES.RDB$USER_TYPE = RDB$TYPES.RDB$TYPE) INNER JOIN RDB$TYPES RDB$TYPES1 ON (RDB$USER_PRIVILEGES.RDB$OBJECT_TYPE = RDB$TYPES1.RDB$TYPE) INNER JOIN RDB$ROLES ON (RDB$USER_PRIVILEGES.RDB$RELATION_NAME = RDB$ROLES.RDB$ROLE_NAME) WHERE ((RDB$TYPES.RDB$FIELD_NAME = 'RDB$OBJECT_TYPE') and (RDB$TYPES1.RDB$FIELD_NAME = 'RDB$OBJECT_TYPE')) ORDER BY RDB$USER_PRIVILEGES.RDB$USER;




- Начало -  - Назад -  - Вперед -