Re: SYSTEM as SYSDBA cannot grant privs on others' tables?

>.... what am I missing?

Security implications. Tables (or any other objects) created in other schemas belong to those schemas.
Table "emp" created in schema Scott belongs to Scott and only Scott can alter/manipulate it.
Scott can however grant object privileges to other schemas or roles. Scott can also grant object privileges with the "WITH GRANT OPTION", which may? solve the problem as you stated it However, I do not like the idea of one super powerful user being able to manipulate all the data in the database.

George Barbour

"Jim Garrison" <jhg_at_acm.org> wrote in message news:397B8A37.6F93FB16_at_acm.org...
> I'm trying to set up a complex set of schemas and want to do
> all the work logged on as SYSTEM. I can create tables in
> other schemas, but when I try to grant privileges on those
> tables (to PUBLIC, for instance) Oracle tells me I have
> insufficient privileges. For example:
>
> grant select on mfg.orders to public;
> ORA-01031: insufficient privileges
>
> I'm logged on as SYSTEM. It makes no difference if I use
> "as SYSDBA" also. As far as I can tell, SYSTEM has all
> necessary privileges.... what am I missing?
>
> --
> Jim Garrison (jhg_at_acm.org)
> PGP Keys at http://www.acm.org/~jhg RSA 0x04B73B7F DH 0x70738D88
Received on Mon Jul 24 2000 - 00:00:00 CDT