| Subject | RDB$ADMIN ROLE in security databese |
|---|---|
| Author | Neagu |
| Post date | 2015-11-30T02:58:51Z |
Hi
Firebird 2.5 introduces the RDB$ADMIN ROLE. In the security database,
it means, the ability to create, drop and alter user accounts. For this
we can use SQL command CREATE or ALTER USER with parameter GRANT/REVOKE
ADMIN ROLE to manage users RDB$ADMIN ROLE in the security database.
When I connect to a database with SYSDBA, I can obtain a list of users,
using an SQL SELECT from RDB$USER_PRIVILEGES, but how can i know if a
user have or not the ADMIN ROLE in the security database ?
Neagoe Basarab
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
Firebird 2.5 introduces the RDB$ADMIN ROLE. In the security database,
it means, the ability to create, drop and alter user accounts. For this
we can use SQL command CREATE or ALTER USER with parameter GRANT/REVOKE
ADMIN ROLE to manage users RDB$ADMIN ROLE in the security database.
When I connect to a database with SYSDBA, I can obtain a list of users,
using an SQL SELECT from RDB$USER_PRIVILEGES, but how can i know if a
user have or not the ADMIN ROLE in the security database ?
Neagoe Basarab
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus