| Dynamic SQL in stored procedures [message #36364] |
Wed, 21 November 2001 00:09  |
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  |
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
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
