Home » SQL & PL/SQL » SQL & PL/SQL » what privileges do we need while using Execute Immediate
what privileges do we need while using Execute Immediate [message #249347] Wed, 04 July 2007 02:48 Go to next message
donind
Messages: 95
Registered: February 2007
Member
Hi,

I am executing a prcodeure which uses dynamic sql inside the procedure which excutes sql insert statements dynamically. But it is happening so.

While executing it is getting hanged.

Any help reallyu appreciated
Re: what privileges do we need while using Execute Immediate [message #249354 is a reply to message #249347] Wed, 04 July 2007 03:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You need direct privilege on the objects you access not via a role.

Regards
Michel
Re: what privileges do we need while using Execute Immediate [message #249365 is a reply to message #249354] Wed, 04 July 2007 03:28 Go to previous messageGo to next message
donind
Messages: 95
Registered: February 2007
Member
Hi,

can u provide me a syntax for that

Thanks in advance
Re: what privileges do we need while using Execute Immediate [message #249368 is a reply to message #249365] Wed, 04 July 2007 03:35 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The syntax is :

grant [privileges you haven't told us] 
   on [object you haven't told us]
   to [user you haven't told us];
Re: what privileges do we need while using Execute Immediate [message #249375 is a reply to message #249368] Wed, 04 July 2007 03:55 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Laughing
Previous Topic: compare two similar tables in different Schemas n the schemas in different databases
Next Topic: pls help
Goto Forum:
  


Current Time: Sun Dec 11 04:29:33 CST 2016

Total time taken to generate the page: 0.05603 seconds