Thanks Mark, I've tried executing fbsvcmgr (from the MS DOS prompt) but both
action_display_user_adm and action_display_user are always returning "no" for
the adm column.
[WI-T3.0.0.30809 Firebird 3.0 Alpha 2]
Kind regards,
Robert
Sorry, the right syntax is CREATE USER ... GRANT ADMIN ROLE (in stead of WITH
ADMIN ROLE). But the problem is the same.
Hi Thomas, I think it is a little bit complexer as one may think.
The admin role in CREATE USER WITH ADMIN ROLE is not registered in
RDB$ROLES/RDB$USER_PRIVILEGES of the **main** database, but I assume it is
registered in the **security** database. It is user specific, not database
specific.
As SYSDBA I like to know which users are granted in the past with the ADMIN
ROLE (as in CREATE USER Test1 PASSWORD 'test' GRANT ADMIN ROLE).
I guess those users have the system defined RDB$ADMIN role assigned in the
security database, but I do not have direct access to the security databae to