I can’t answer the password dilemma but I looked in the Help file for CREATE SCHEMA and AUTHOR is short for AUTHORIZATION and is used to define the name of the database. It also states if no owner name is defined it defaults to PUBLIC which allows everyone to have full access to the database.
Enquiring minds wanted to know. Paul Buckley From: [email protected] [mailto:[email protected]] On Behalf Of Alastair Burr Sent: June 15, 2017 10:34 AM To: karentellef via RBASE-L <[email protected]> Subject: Re: [RBASE-L] - Password error I spent days editing the unload file(s); using SET USER and a few times I thought I had conquered it but eventually the need for NONE appeared again. As far as I recollect (always dangerous) neither NONE nor PUBLIC ever used to appear in the unload file - only the owner password if one existed for the owner name. (Prior to that only the owner name.) PUBLIC was implied by not having an owner or added via the GRANT system. NONE just seems to have appeared but when I don't know. It can/should be used to remove a password according to help. Maybe R:Base is suddenly taking it literally and storing NONE as the password but that wouldn't explain why it suddenly decides to need it. I presume AUTHOR is the SQL way of saying OWNER? Regards, Alastair. On 15/06/2017 14:13, karentellef via RBASE-L wrote: 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 <mailto:[email protected]> <[email protected]> To: R:Base Listserver 2016 <mailto:[email protected]> <[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 <mailto:[email protected]> <[email protected]> Reply-To: [email protected] <mailto:[email protected]> To: [email protected] <mailto:[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 but it still comes back. I gave 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 folder as well in my back-ups in case that's relevant somehow. Good luck, Regards, Alastair. On 14/06/2017 15:47, [email protected] <mailto:[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 to [email protected] <mailto:[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] <mailto:[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] <mailto:[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] <mailto:[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.
