Re: ORA-01031:Inufficient Privileges

From: <alistair.thomson_at_sphinxcst.co.uk>
Date: Wed, 23 Aug 2000 10:39:51 GMT
Message-ID: <8o09ll$2o7$1@nnrp1.deja.com>

Grants on objects MUST be made by the owner of the objects. No other user can do this including SYS and SYSTEM. Security you know :)

Alistair

In article <399BD01C.455C_at_yahoo.com>,
connor_mcdonald_at_yahoo.com wrote:
> Allen wrote:
> >
> > I am getting this error when I am trying to execute a GRANT:
> >
> > GRANT INSERT ON "schema_owner"."the_table" TO "another_user";
> >
> > ORA-01031:Inufficient Privileges
> >
> > When I am executing the GRANT I am logged in as SYSTEM which
> > has DBA privileges. WTF? When I look at the help or the error
message
> > it tells me to make sure that DBA privileges exist... well they
do. Am I
> > missing a role?
>
> Take a look at
>
> http://www.oracledba.co.uk/tips/grants.htm
>
> HTH
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk
>
> We are born naked, wet and hungry...then things get worse
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Aug 23 2000 - 05:39:51 CDT