Subject | Re: [firebird-support] Re: Firebird 2.x security and non-SYSDBA users |
---|---|
Author | Christian Waldmann |
Post date | 2009-05-15T11:46:07Z |
Ivan Prenosil schrieb:
my additional user modify the USERS.
Many thanks
Christian
>> You are right, when modified security2.fdb to allow adding new users, then it's a feature I have created.I think this is the right hint. I will at least modify the view to let
>>
>> My user to add and delete users is the ADMINISTRATOR. So I have added the following grant to the security2.fdb by moving it from
>> the firebird root directory and moving it back afterwards:
>>
>> GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON USERS TO ADMINISTRATOR;
>>
>> But why does the security service block the access only in one direction.
>
> Just look at view USERS in security database ...
>
> Ivan
my additional user modify the USERS.
Many thanks
Christian