Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Is the owner of a table the schema?

Re: Is the owner of a table the schema?

From: Eric Givler <egivler_at_flash.net>
Date: Sat, 09 Sep 2000 17:09:45 GMT
Message-ID: <t9uu5.1036$oc3.83337@news.flash.net>

> This is not correct. There are only two cases where an object privilege
> can be granted. An object privilege can be granted by the owner of the
> object or to anyone who has been granted the object privilege with the
> ADMIN option. For proof, see the example below with two users (test1 &
> test2):

Oh, I believe what you are saying, but can you run your script again with the "grant any table" privilege? I think I confused this with the ability to grant
any system privilege (grant any privilege). Received on Sat Sep 09 2000 - 12:09:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US