I've never had a database with an owner PW so I don't know much
about them. But when I unload schema for my personal consulting
database it says:
CREATE SCHEMA AUTHOR CONSULT PUBLIC
I'm not sure why mine says 'PUBLIC" rather than "NONE". I do not
have any privileges granted. Can you try changing it to Public and
see if that sticks?
And I'm curious myself: what does the word "AUTHOR" mean? Is
that always there, or does it mean something?
Karen
-----Original Message-----
From: Alastair Burr <[email protected]>
To: R:Base Listserver 2016 <[email protected]>
Sent: Thu, Jun 15, 2017 5:42 am
Subject: Fwd: Re: [RBASE-L] - Password error
For some reason this went direct to Mike rather than the list.
-------- Forwarded Message --------
Subject:
Re: [RBASE-L] - Password error
Date:
Wed, 14 Jun 2017 17:02:25 +0100
From:
Alastair Burr <[email protected]>
Reply-To:
[email protected]
To:
[email protected]
I have the exact same problem - mentioned here a good few months back.
I can give you the solution but I cannot get rid of the problem - it keeps
coming back.
The solution is that the "null" or non-existent password gets sets to "none"
for no obvious reason.
If you type in the password as "none" you will get in as normal.
If you unload to a file and edit it you will see it in the Create Schema
command. I've edited it endlessly butit still comes back. Igave up and cut my
loses and now just enter "none" - I can't waste more time on it. It's just one
database; my other four are fine.
For what it's worth, I loop through and autochk, copy (reload) to a new
folderas well in my back-ups in case that's relevant somehow.
Good luck,
Regards,
Alastair.
On 14/06/2017 15:47, [email protected] wrote:
Good day:
I have a daily backup routine that loops through about 20 databases. The
program connects to a database, AUTOCHKs it and then copies it to a backup
folder.
There is one database that generates the following error when the program
attempts to connect to it: -ERROR- The current password is not correct for
this user identifier. (2867)
The owner of the database is set to public and there has never been a password
associated with the database.
Entering a bogus password or clicking through it generates this message:
-ERROR- Incorrect password. User identifier has been changed to PUBLIC. (2870)
After which the database gets backed up.
I cannot find anything that would indicate why this is happening to this one
particular database. I've checked it, I've rebuilt it and still I get the
message.
Using eXtreme 9.5, I would appreciate some suggestions or insight into why this
happens or what I can look for.
Thanks for any help.
Mike Ramsour
AK Steel Coshocton Works
Quality Department
Phone: 740-829-4340
Cell: 740-502-1659
Confidentiality Notice
This message is intended exclusively for the individual or entity to which it
is addressed and may contain privileged, proprietary, or otherwise private
information.
If you are not the named addressee, you are not authorized to read, print,
retain, copy or disseminate this message or any part of it. If you have
received this message in error, please notify the sender immediately by e-mail
and delete all copies of the message.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
[email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
