Re: Granting procedures

From: John Chiu <johnymc_at_netscape.com>
Date: Sat, 11 Sep 1999 05:47:45 -0400
Message-ID: <37DA2541.85AB6AF3@netscape.com>

Is SYSTEM default to dba role which has all privileges granted to all schema?

Thanks in advanced.

John Chiu
johnc_at_relsol.com

Thiru wrote:

> ANN should have granted SYSTEM, the Execute privilege with GRANT option for
> the System user to be able to Grant privileges on that Procedure to any
> other User..
>
> -Thiru
>
> cblum_at_hotmail.com wrote:
>
> > Hello,
> >
> > As SYSTEM user, I am trying to grant ANN's procedure to BOB. I receive
> > an error message that I do not have permission to perform this grant.
> > If I log in as ANN, I am able to grant the procedure to BOB.
> >
> > What do I need to do to allow the SYSTEM user to grant ANN'S
> > procedures?
> >
> > Thanks.
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
Received on Sat Sep 11 1999 - 04:47:45 CDT