Bonjour,
J'ai un problème inhabituel et je ne sais pas comment y remédier.
Lorsque j’exécute ceci sur mon propre schéma, ça passe. La table est crée:
create table ABSTRACT_PRINCIPAL_AUDIT as select * from ABSTRACT_PRINCIPAL where 0=1;
Lorsque j’exécute ceci, ça passe aussi:
1 2 3 4
| begin
EXECUTE IMMEDIATE 'create table ABSTRACT_PRINCIPAL_AUDIT as select * from ABSTRACT_PRINCIPAL where 0=1';
end;
/ |
Maintenant lorsque je fais ça, j'ai des erreurs:
1 2 3 4 5 6 7
| create or replace procedure create_table as
begin
EXECUTE IMMEDIATE 'create table ABSTRACT_PRINCIPAL_AUDIT as select * from ABSTRACT_PRINCIPAL where 0=1';
end;
/
exec create_table; |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
| ORA-01031: insufficient privileges
ORA-06512: at "MONSCHEMA.CREATE_TABLE", line 3
ORA-06512: at line 1
01031. 00000 - "insufficient privileges"
*Cause: An attempt was made to change the current username or password
without the appropriate privilege. This error also occurs if
attempting to install a database without the necessary operating
system privileges.
When Trusted Oracle is configure in DBMS MAC, this error may occur
if the user was granted the necessary privilege at a higher label
than the current login.
*Action: Ask the database administrator to perform the operation or grant
the required privileges.
For Trusted Oracle users getting this error although granted the
the appropriate privilege at a higher label, ask the database
administrator to regrant the privilege at the appropriate label. |
Quelqu'un peut me dire d'où vient le problème?
Merci
Partager