Information générale
Catégorie:
Déclencheurs, séquences et procédures stockées
Titre:
ORA-01031 Create User in Procedure
I have a procedure that is executed by an insert trigger that works fine when I am connected as Sys with Sysdba rights when I insert a row of data. When I am connected as a different user I receive the error message ORA-01031: insufficient privileges. I can run the single statement within the procedure through SQL Plus with no problem. Any idea as to what privilege I need to assign other users so that this procedure will execute correctly. The other user is assigned execute any procedure.
create or replace procedure cr8user (cuser IN varchar2, cpass IN varchar2) as
pragma autonomous_transaction;
begin
execute immediate 'create user ' || cuser || ' profile default identified by ' || cpass || ' default tablespace users temporary tablespace temp account unlock';
end cr8user;
This is on Oracle 8i, 8.1.5. Any help would be greatly appreciated.
Thanks,
Greg
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement