Re: [firebird-support] Re: Delegating SYSDBA and enumerating users

---In firebird-support@yahoogroups.com, wrote : ... > Now I have a couple of questions for you: > > 1. Do you know if it is possible in gsec to log in under a custom ROLE? Sure, it is possible > Further to this, is there a way of GRANTing the custom ROLE the

Re: [firebird-support] Re: Delegating SYSDBA and enumerating users

Thanks Vlad for your replies. In response to your first reply: a) Yes, I had read "Escalating RDB$ADMIN Scope for User Management" but I appreciate the link and others may too. My users with admin access have already been granted the RDB$ADMIN ROLE. b) gsec -role - that is great to know the

[firebird-support] sysdba lost password

hi all I know the way to reset password for admin : i replace my file with another one which i know the password. But in this case i lost all users account how can i reset admin password and recover my users account ? Regards

[firebird-support] Re: Delegating SYSDBA and enumerating users

A little sample with Firebird 2.5 I added ordinary users 'user1' and 'user2' and admin user 'adm1'. Now try to display list of users 1. Use sysdba account: firebird\bin>gsec -user sysdba -pass masterkey -display user nameuid gid admin full name

[firebird-support] Re: Delegating SYSDBA and enumerating users

---In firebird-support@yahoogroups.com, wrote : > In a production environment using Firebird v2.5, we need to delegate > authority of USER CRUD operations to more than one person without these > admins sharing the SYSDBA user and password. Does you read this chapter