Thank you. That did it for me.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak
Memon
Sent: Sunday, August 15, 2004 11:10 AM
To: RBG7-L Mailing List
Subject: [RBG7-L] - Re: Database Owner, User ID and Password.
At 09:49 AM 8/15/2004 -0400, Benjamin Strickland wrote:
>What is the correct procedure for changing the Owner in a
>database and then creating a Password for the purpose of
>requiring this information before the database will connect.
Benjamin,
Here's how:
A. To change the OWNER of a database
01. Start RBG7
02. CONNECT dbname
03. At the R> prompt:
RENAME OWNER NONE TO newownername
04. DISCONNECT
05. EXIT
B. To automatically CONNect the database with OWNER password
01. Start RBG7
02. At the R> prompt:
CONNECT dbname IDENTIFIED BY ownerpassword
OR
Use the above command in application startup DAT file.
OR
Use the above command in RBASE.DAT file
C. To change existing OWNER password
01. Start RBG7
02. At the R> prompt:
CONNECT dbname IDENTIFIED BY ownerpassword
RENAME OWNER oldownerpassword TO newownerpassword
D. You may also use Utilities | Set User ID and Password
or GUI User Privileges option of RBG7 Main Menu.
Have fun!
Very Best R:egards,
Razzak.
