Re: Is the owner of a table the schema?

Doesn't that stink. I thought with there being a "grant any privilege", "grant any role", insert any table, delete any table, update any table, and select any table that there had to be a "GRANT ANY TABLE". Oh well.... Sorry for introducing so much confusion. Guess I better start trying a couple of things BEFORE posting.

Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote in message news:39BE3A79.B44A9B20_at_edcmail.cr.usgs.gov...
> Eric,
>
> There is no "grant any table" privilege. See the following:
>
> SQL> grant grant any table to testuser;
> grant grant any table to testuser
> *
> ERROR at line 1:
> ORA-00990: missing or invalid privilege
>
> There is a "select any table" privilege. Maybe this is what you were
> talking about. A DBA can grant this to anyone and they can then see any
> table. The DBA does not even need select privileges on the object in
> question. But the DBA can not grant select on a specific table unless
> the DBA has been granted select on that table with the ADMIN option.
>
> HTH,
> Brian
>
>
> Eric Givler wrote:
> >
> > > 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).
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
Received on Wed Sep 13 2000 - 07:38:59 CDT