Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA-01031:Inufficient Privileges
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 worseReceived on Thu Aug 17 2000 - 06:44:28 CDT