[firebird-support] RDB$ADMIN ROLE in security databese

 

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

__._,_.___

---

Posted by: Neagu <neagoe@gmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___