Ahh... I see now. Thanks for that. just tried it - and it works fine
without name and password - and 'other' doesn't need rw access to
security2.fdb anymore.

Having said that - the owner (root) still does, and I now have to give
PUBLIC rights to objects in our database - but that's ok.

Thanks for all the help!

Peter Lee

Philippe Makowski wrote:

> Peter Lee [09-07-01 06.46] :
>
>> I've just realised that we are supplying a username and password when
>> connecting. Could this be causing the problem?
>>
>
> yes, see what I did (no user no password) :
>
>
>>>>> isql ./tempo/firebird_db/coll1.fdb
>>>>>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>
>
>

--
Peter Lee ptle@...
-----------------------------------------------------------------------
Rising Software Australia Pty. Ltd. http://www.risingsoftware.com/
Publishers of 'Auralia' - Ear Training and 'Musition' - Theory Training
Ph: +61 3 9481 3320 FAX: +61 3 9481 3380 USA Freecall: 1 888 667 7839