Re: Is the owner of a table the schema?

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!
========================================