[RBG7-L] - Re: Database Owner, User ID and Password.

[A. Razzak Memon]

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.