Subject RE: [firebird-support] overwrite security file
Author Goutam Paruchuri
Thanks helen.
I got it working, just was about to email the group. I did that and
restarted the server. I solved one issue and had an other.
The problem really is caused when the file security.fdb is copied over
from the CD to disk, it puts a read only property.
The db connection or gsec would not work and returns "no read-write
permissions on the database "...All works as soon as I manually turn the
readonly off.

While I can do that programatically, iam just curious to know why I get
no read-write permissions. I do have read-only.
Does firebird server write something to the security database.

Thanks !
Goutam



> -----Original Message-----
> From: Helen Borrie [mailto:helebor@...]
> Sent: Friday, December 17, 2004 6:20 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] overwrite security file
>
>
>
> At 05:33 PM 17/12/2004 -0500, you wrote:
>
> >Can i overwrite the security.fdb file from one installation to the
> >other without affecting anything else. The fb server seems to hang.
> >
> >Here is the requirement , without requiring to do gsec, i
> need to add
> >users and grant permissions. i was thinking to overwrite the default
> >security.fdb file with the one i need.
>
> You can do that, but not while the Firebird server is
> running. Under Fb 1.5, security.fdb is held open in a
> read-only transaction. Under SS, the file has an exclusive lock.
>
> ./hb
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~--> Make a clean sweep of pop-up ads.
> Yahoo! Companion Toolbar.
> Now with Pop-Up Blocker. Get it for free!
> http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>


Confidentiality Notice
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.