Home » SQL & PL/SQL » SQL & PL/SQL » Privileges create any table
Privileges create any table [message #266959] Wed, 12 September 2007 01:55 Go to next message
donind
Messages: 95
Registered: February 2007
Member
Hi,

I am having a DBA role. I have created one procedure which conatins dynamic sql to create a table. When i tried to execute this procedure. Its saying insuffcient privileges. When i have executed below command its excuting fine.

grant create ant table to user1;

DBA role already includes this privilege then whats the need of granting this privilege.

Can anyone give explanation on this.

Thanks in advance
Re: Privileges create any table [message #266960 is a reply to message #266959] Wed, 12 September 2007 01:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Roles are no enabled in procedure.

Regards
Michel
Re: Privileges create any table [message #266961 is a reply to message #266960] Wed, 12 September 2007 02:04 Go to previous messageGo to next message
donind
Messages: 95
Registered: February 2007
Member
How to enable those roles in procedure. can give some exapmle for that.

It will help me a lot.

thanks

[mod-edit] removed illiterate IM words.

[Updated on: Wed, 12 September 2007 07:45] by Moderator

Report message to a moderator

Re: Privileges create any table [message #266969 is a reply to message #266959] Wed, 12 September 2007 02:24 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

grant execute any procedure
Re: Privileges create any table [message #266970 is a reply to message #266961] Wed, 12 September 2007 02:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Give option "authid current_user".

Regards
Michel
Re: Privileges create any table [message #266972 is a reply to message #266969] Wed, 12 September 2007 02:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
NEVER grant "execute any procedure". Don't you see: ANY procedure! Give me that and I do what I want in less than 30 seconds.

In addition, this is useless in this case as the problem is not not being able to execute a procedure but not being able to create a table inside a procedure.

Regards
Michel
Re: Privileges create any table [message #266985 is a reply to message #266959] Wed, 12 September 2007 03:24 Go to previous messageGo to next message
donind
Messages: 95
Registered: February 2007
Member
Hi Arju,

Its not a problem with execution of procedure. Its a problem with creation of table inside a procedure.

Thanks for ur reply.
Re: Privileges create any table [message #266998 is a reply to message #266959] Wed, 12 September 2007 04:08 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Yes, I misleadingly interpret the message.
Previous Topic: Datatypes
Next Topic: To know privileges under each role
Goto Forum:
  


Current Time: Tue Dec 06 04:41:30 CST 2016

Total time taken to generate the page: 0.16888 seconds