Bonjour,
Je tente de créer une vue sur deux tables appartenant chacun à une base différente, et j'ai un message de privilèges insuffisants.

CREATE VIEW DOSSIER_ALL AS
SELECT * FROM CONVERGENCE.Dossier
UNION
SELECT * FROM CONVERGENCE_ARCHI.Dossier

ORA-01031: insufficient privileges

J'ai ceci des deux côtés (CONVERGENCE et CONVERGENCE_ARCHI) :
SQL> select privilege from dba_sys_privs where grantee = 'RESOURCE';

PRIVILEGE
----------------------------------------
CREATE TYPE
CREATE TABLE
CREATE CLUSTER
CREATE TRIGGER
CREATE OPERATOR
CREATE SEQUENCE
CREATE INDEXTYPE
CREATE PROCEDURE

SQL> select * from dba_sys_privs where privilege ='CREATE VIEW';

GRANTEE PRIVILEGE ADM
------------------------------ ---------------------------------------- ---
IX CREATE VIEW NO
DBA CREATE VIEW YES
SYS CREATE VIEW NO
XDB CREATE VIEW NO
DMSYS CREATE VIEW NO
MDSYS CREATE VIEW NO
WKSYS CREATE VIEW NO
WKUSER CREATE VIEW NO
CONNECT CREATE VIEW NO
OLAPSYS CREATE VIEW NO
OLAP_USER CREATE VIEW NO
CONVERGENCE CREATE VIEW NO
CONVERGENCE_ARCHI CREATE VIEW NO
RECOVERY_CATALOG_OWNER CREATE VIEW NO


Sauriez vous me sauver la mise?

RESOLU
GRANT CREATE ANY VIEW to convergence_archi
GRANT SELECT ANY TABLE to convergence_archi

Merci à moi même...

Configuration: Oracle 10