[RBASE-L] - Changing OWNER Password (was Re: Funny That You Should MentionIt ...)

[A. Razzak Memon]

At 12:06 PM 6/9/2003 -0400, Dan Champion wrote:

Does anyone have some good advice on the topic of Database Ownership.
We just recently took our PUBLIC 'ly owned database, but now the company
owner would like to be able to restrict access to one of the tables.   I Set
him as OWNER, and Granted access (table by table) to the users.  Now...
unload/reloads can't be done by anyone but the owner?
How do we set it back to public till we figure a better way to do this?
Dan,

A few options:

A. At the R> prompt:

01.     CONNECT dbname IDENTIFIED by OwnerPasword
02.     SET NULL -0-
03.     OUTP dbname.UNL
        UNLOAD ALL
        OUTP SCREEN
04      Open dbname.UNL file in RBEDIT or any text editor and then
        change the structure accordingly.
B.

01.     CONNECT dbname IDENTIFIED by OwnerPasword and then

        Use GRANT option to take care of everything.

        For complete details: http://www.RSyntax.com

Hope that helps!

Very Best R:egards,

Razzak.