Re: ORA-01031:Inufficient Privileges

"Allen" <allen.brost_at_motorola.com> wrote in message news:399C17F7.B511F1B2_at_motorola.com...
> 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?
>

It's funny, but this one keeps coming up time and time again! The *only* person who can grant object privileges on an object is the *owner* of that object -with the one small exception that the owner can previously have granted you a privilege 'with grant option' -at which point, you become an administrator of that specific privilege, and can grant it and revoke it from whomsoever you please (except you can't revoke it from the owner himself).

You can be the Lord Almighty herself, and still not have rights on scott.emp!

Specifically, having the DBA role means you possess all the *system* privileges -but zilch object privileges.

Regards
HJR Received on Fri Aug 18 2000 - 17:35:18 CDT