I've not had a chance to play with this again until now... but have just
tried it once more. The 'security2.fdb' file has owner of 'root' and
group 'admin' in our deployed bundle. The user that I'm testing this
under is not root and isn't in the admin group.

Permissions are -rwxrwxr-x. This gives the 'cannot attach to security
database' error message. However - if the permissions are -rwxrwxrwx
then it works fine.

Just to clarify - does firebird embedded definitely need write access to
security2.fdb?

I've just realised that we are supplying a username and password when
connecting. Could this be causing the problem? I've also just read
that in the release notes that this is not required in FB 2?

Thanks,

Peter Lee

Philippe Makowski wrote:

> Peter Lee [09-06-24 04.27] :
>
>> Sorry... one more question - if the database.fdb and security2.fdb file
>> are not owned by the current user, or the current user isn't in the
>> group specified for those files, if RW is given to 'others', then
>> everything should work ok?
>>
> if you are using direct local protocol (Classic embeded), security2.fdb is not involved
> only rigths on db file are involved
>
>
> so if I do :
>
>>> isql ./tempo/firebird_db/coll1.fdb
>>>
> then I only need to have rw rights on that file
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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