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