Re: [firebird-support] How to retrieve list of users granted with the admin role

2014-06-20 Thread r...@xs4all.nl [firebird-support]
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

Re: [firebird-support] How to retrieve list of users granted with the admin role

2014-06-20 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 20 Jun 2014 04:53:39 -0700, r...@xs4all.nl [firebird-support] firebird-support@yahoogroups.com wrote: 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

Re: [firebird-support] How to retrieve list of users granted with the admin role

2014-06-19 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 18-6-2014 15:23, r...@xs4all.nl [firebird-support] wrote: 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

[firebird-support] How to retrieve list of users granted with the admin role

2014-06-18 Thread r...@xs4all.nl [firebird-support]
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

Re: [firebird-support] How to retrieve list of users granted with the admin role

2014-06-18 Thread Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
Hi Robert, roles are database specific. Check RDB$ROLES and RDB$USER_PRIVILEGES, you'll probably find out what you need - if not, come back and ask, I'll dig in more details. Thomas Am 18.06.2014 15:23, schrieb r...@xs4all.nl [firebird-support]: As SYSDBA I like to know which users are