Hi,

I have recently moved a database from one server to another. I did this by
simply copying the data directory onto the new server, then adding a new
database on the server and giving that directory as the db location.

Problem is, somewhere along the line, I've done somthing to mess up the
security. I can get into the db without supplying user/password, and there
are no users showing in the 'Users' branch of Control Centre. However if I
go to Database, Properties, Security, it seems that security is enabled, but
if I try to disable it, it give me an error saying there is no security to
disable. Anyone know how I can get security re-enabled and my users set up
properly again...?

TIA,

Chris.

--
Please remove shoes to reply

But what ... is it good for?
- Engineer at the Advanced Computing Systems Division of IBM, 1968,
commenting on the microchip.

Additional Info:

If I try to open the 'X$User' or 'X$Rights' tables, I get an error message :
'Owner Name is invalid'

C.

--
Please remove shoes to reply

But what ... is it good for?
- Engineer at the Advanced Computing Systems Division of IBM, 1968,
commenting on the microchip.

When you copied the database over, you forgot to copy over the USER.DDF and
RIGHTS.DDF files. Go back and copy these files to the new location, and you
should be all set.
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: August, 2004: See our web site for details!


ChrisM wrote:

Hi Bill,

Thanks for your suggestion. Hey, are you the only person that ever answers
any questions in this group? ;-)


Hmm,
No I have those.

A little more info though, first time I tried, when I tried to open the DB
on my new server it asked for a username/password but didnt recognise the
ones from the original server.

I went back to the original server, turned security off and recopied the
files to the new server. At this point, I guess it is possible that I got
the versions of USER and RIGHTS.DDF out of sync.

Is there a way to 'rebuild' the security in some way? or do I need to revert
to a previous version of the files...?

Thanks,

Chris,.

--
Please remove shoes to reply

ChrisM wrote:

It all depends on how badly it is damaged. If the DDF's contain the USER.DDF
and RIGHTS.DDF files, then they should exist. Also, each should have the same
owner name, which will be the Master Password for all versions up to
Pervasive.SQL V8.5. This should match the Master Password stored (and
encrypted) in USER.DDF.

If you know what the master password SHOULD be, then you can blow away the
USER/RIGHTS tables, manually remove the owner names from the rest of the DDF
files with BUTIL -CLROWNER, and then try to manually strip out the references to
USER/RIGHTS in File/Field/Index tables.

It's not pretty, but it can be done. Might be simpler, though, to just restore
a copy from backup & go from there...
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: November 16-19, 2004: See our web site for details!