Home » SQL & PL/SQL » SQL & PL/SQL » ddl in PL/SQL procedure
ddl in PL/SQL procedure [message #9650] Wed, 26 November 2003 08:50 Go to next message
ksoule
Messages: 13
Registered: November 2003
Location: Austin, TX
Junior Member
i try to execute ddl code in pl/sql procedure on Oracle8. thus, i use this package dbms_utility.exec_ddl_statement('');
e.g dbms_utility.exec_ddl_statement('CREATE USER TOTO');
although i have DBA role , i receive this error message "ORA-01031 insufficient privileges"

SQL*PLUS with the same connection , that's happens well.
could someone help me ?

Report message to a moderator

Re: ddl in PL/SQL procedure [message #9651 is a reply to message #9650] Wed, 26 November 2003 09:19 Go to previous messageGo to next message
Adrian Billington
Messages: 139
Registered: December 2002
Senior Member
Dynamic SQL doesn't see inside roles. You need an explicit CREATE USER system privilege for what you are trying to do.

Regards
Adrian

Report message to a moderator

Re: ddl in PL/SQL procedure [message #9661 is a reply to message #9651] Thu, 27 November 2003 02:46 Go to previous message
ksoule
Messages: 13
Registered: November 2003
Location: Austin, TX
Junior Member
happens well

regards

Report message to a moderator

Previous Topic: restraints on not null?
Next Topic: cursors
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 13:49:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.