Home » SQL & PL/SQL » SQL & PL/SQL » Dynamic SQL in stored procedures
Dynamic SQL in stored procedures [message #36364] Wed, 21 November 2001 00:09 Go to next message
Srinivasa varadhan
Messages: 1
Registered: November 2001
Junior Member
Using execute immediate, if i execute a ddl from PL/SQL block, it works well. if i use the same statement from pl/sql stored procedure and execute it,
it says "insufficient privileges". i tried loging in
as a user who has got DBA rights also. what is the actual privilege to be granted for a user to execute a
stored procedure which contains the dynamic sql.
please get back to me as soon as possible.
bye

----------------------------------------------------------------------
Re: Dynamic SQL in stored procedures [message #36365 is a reply to message #36364] Wed, 21 November 2001 01:37 Go to previous message
Giridhar
Messages: 38
Registered: May 2001
Member
If we want to execute a stored object (procedure or function), we should have execute privilege for that object.We need not have select privilege for the tables used in the stored procedure or function.

Giridhar

----------------------------------------------------------------------
Previous Topic: Null varchar
Next Topic: string to recordtype conversion
Goto Forum:
  


Current Time: Sun May 31 02:27:26 CDT 2020