Re: Privileges Issue

Jimbo1 wrote:
> Hello there,
>
> I'm currently experiencing some fun and games with System Privileges in
> Oracle 8.1.7 (An upgrade to 10gR2 is taking place in January 2007, but
> that's not relevant to this question. It's just a pre-emptive answer to
> any 'helpful' individuals who advise an upgrade).
>
> In a nutshell, I'm trying to grant the SELECT privilege on a table in
> another schema to a another seperate schema. Sounds simple eh? The
> schema I'm connecting to in order to do this has been granted the DBA
> role, so this should not be a problem.
>
> Anyway, let's say my schema with the DBA role is called Schema 1.
>
> I'm connecting to Schema 1 and running the following statement:
>
> GRANT SELECT ON Schema2.tableA TO Schema3;
>
> I'm getting the following exception:
>
> ERROR at line 1:
> ORA-01031: insufficient privileges
>
> The DBA role has the GRANT ANY PRIVILEGE privilege.
>
> I am totally confused. Does anybody know what I'm missing here?
>
> Thanks in advance.
>
> James

There's a discussion about this very issue here:

http://groups.google.co.uk/group/comp.databases.oracle.server/browse_thread/thread/f67b9b45cc41b88c/#

HTH -g Received on Fri Jul 14 2006 - 10:17:13 CDT