Ahh... Ok. Now I understand. I will have the Owner do and unload and I will edit the file and set the owner back to public
He didn't realize that by taking ownership it would lock me (developer/user) from being able to do all that I needed to do.
Thanks for your time. Dan
At 08:20 PM 6/9/2003 -0400, you wrote:
Dan,
If you do what I suggested in Option A, you should be able to set everything back to PUBLIC.
You CAN edit the file and set everything accordingly!
To do that, you NEED to CONNECT as owner of the database first.
Do you still have the access to the database as owner?
Very Best R:egards,
Razzak.
At 08:19 PM 6/9/2003 -0700, Dan Champion wrote:
Ok, So, If I read this right.... A. = I am right... only the owner can do the unload/reload which he doesn't want to do. and B... sure don't understand B... use the grant option to take care of EVERYTHING? The question was, how do I UNDO giving the onwer total control. He wants to lock us all out of one table, but thinks things can continue as normal. They can't... now he hea to do my job and maintain the database (according to example A) and B does not give ME control of the database. I am really more confused than I was to begin wtih. I think assigning the owner of our company. OWNERship of the database was a mistake. I should have left it PUBLIC so I can still maintain the data.
How do I undo giving him ownership... I tried setting the owner as public but get an error message about SQL not working if I do.
(please forgive any misspellings, I had an accident with my eyest today and can't see what I am typing)
Dan
At 12:15 PM 6/9/2003 -0400, you wrote:
>
>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.
>
Dan Champion P.O. Box 223 Grandville, MI. 49428-0223 www.championsolutions.net
