Privileges Issue

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 Received on Fri Jul 14 2006 - 10:15:07 CDT