Re: Granting priveleges

"Fim Tox" <tim_at_blueheath.com> a écrit dans le message de news: d4e73249.0202060526.2bf59f08_at_posting.google.com...
> I've created a user fred who has his own schema.
> I've created a user joe who I want to be able to
> update/insert/delete/select any table in fred's schema.
> So.. I log in as SYS (or SYSTEM, the effect is the same) and type:
> grant update,insert,delete,select on fred.mytable to joe;
> and it complains saying:
> ORA-01929: no privileges to GRANT
> I thought SYS could do anything?
> So.. I explicitly add the GRANT ANY PRIVELEGE system privilege to SYS,
> and try again.
> I get the same result.
> What's going on??
> Help!!!!

Hello,

try to connect as fred and normaly you could do your grant to joe

hope it's help Received on Wed Feb 06 2002 - 12:13:06 CST