Re: database security



Sounds like the DDF's might be bad. Try restoring them from a backup
copy with the engine shut down (which should clear the security stuff
out). You can try re-enabling security right away, but I'd recommend
running the Check Database Wizard against the DDF's themselves first to
be sure that the DDF's are properly defined.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach@xxxxxxxxxxxxxxxxxxxx
http://www.goldstarsoftware.com
*** Chicago: Pervasive.SQL Service & Support - November, 2005 ***
*** Chicago: Pervasive DataExchange Class - November, 2005 ***

Dave wrote:

> hi all,
>
> i'm having a play & turned on database security on a test box, as we
> have found that accessing the database via ODBC from a linux box
> connects (and allows sql updates) without specifying a
> username/password!
>
> i now want to turn the database security off, but when I try (from
> PCC), I get an error :
>
> [Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine
> Interface][Data Record Manager]This database has no security so the
> command has no effect.
>
> I find this a bit odd, as there are users in the Users pane, users in
> the X$USer table, and the security tab on the properties of the
> database says "Database Security: Enabled".
>
> I get a similar error if I try and delete one of the users - "This
> database has no security so the command has no effect."
>
> Anyone got any ideas?
>
> thanks
> Dave

.



Relevant Pages

  • Re: User Rights Assignment - not available - Resolved
    ... Then copy the security file from the \windows\repair ... If none of that works I would try an upgrade/repair install ... shows user rights and use the Resource Kit command line tool NTrights to ... This operation may find that this database is corrupt ...
    (microsoft.public.windowsxp.security_admin)
  • Re: User Rights Assignment - not available
    ... Then copy the security file from the \windows\repair folder. ... pristine install. ... Somarsoft to see if it shows user rights and use the Resource Kit command ... This operation may find that this database is corrupt ...
    (microsoft.public.windowsxp.security_admin)
  • Re: setting a password on a button on the switchboard
    ... Could you send me the sample database for the fourth option (4. ... > Security in an Access database can probably be broken down into two big ... > points about being easier than User Level Security, ... > What type of data are you trying to protect? ...
    (microsoft.public.access.forms)
  • Re: access 2003
    ... security in access 2003. ... The data will go on the server and the program database ... than the alternative of creating an mde file. ... MDW file from the written record. ...
    (microsoft.public.access.conversion)
  • Re: access 2003
    ... security in access 2003. ... The data will go on the server and the program database ... than the alternative of creating an mde file. ... MDW file from the written record. ...
    (microsoft.public.access.conversion)