Subject | Re: [firebird-support] Availible users as no-sysdba-user in FB 2 |
---|---|
Author | Björn Reimer |
Post date | 2007-10-10T18:53:11Z |
>>Thank you, but that's no solution for me as I don't give away the
>> That's not a good solution.
>> Is there any other idea?
> no - not with fb2's new security model, unless you make the mods to
> security2.fdb and distribute the modified version of it.
> That's what I do.
> OR
> in the admin tool of choice, you register 2 servers, one as creator and one
> as SYSDBA, use the owner registered server to do your dev work, and the
> SYSDBA registered server to do the permissions.
> if you use roles, then role admin is carried out without seeing WHO
> (specific users) on the server. You can grant roles to users also without
> seeing them, with a grant statement.
> but yes, the full use of gui grant managers to individual users is not going
> to work with the standard install unless you are SYSDBA.
sysdba pw to others but db accounts.
Due to the architecture of separating user and roles in different dbs
I think I do have to build an own admin tool...
--
Björn Reimer, Datenbanken und DV-Verfahren