Home » SQL & PL/SQL » SQL & PL/SQL » Grant previlages
Grant previlages [message #262397] Sun, 26 August 2007 23:37 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Dear sir,

how can i grant previlages to DBMS_LOCK packages from sys schema.

The package is in sys, and i've to grant privs to hubs. its an inbuilt PL/SQL package.


please send reply for my requirements..

Arunkumar.
Re: Grant previlages [message #262403 is a reply to message #262397] Sun, 26 August 2007 23:48 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
For grant any package use the following command

grant execute on [package_name] to [user];
Re: Grant previlages [message #262404 is a reply to message #262397] Sun, 26 August 2007 23:48 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/r0000962.htm
Re: Grant previlages [message #262405 is a reply to message #262397] Sun, 26 August 2007 23:50 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

please send clear commands.
Re: Grant previlages [message #262407 is a reply to message #262397] Sun, 26 August 2007 23:56 Go to previous messageGo to next message
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
Senior Member
grant execute on DBMS_LOCK to hubs;
Re: Grant previlages [message #262415 is a reply to message #262397] Mon, 27 August 2007 00:07 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Fine and Thanks..
Re: Grant previlages [message #262436 is a reply to message #262405] Mon, 27 August 2007 00:55 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
muzahidul islam wrote on Mon, 27 August 2007 06:48
For grant any package use the following command

grant execute on [package_name] to [user];


akkumar81 wrote on Mon, 27 August 2007 06:50
please send clear commands.

How lazy can you get?
If you continue to refuse to put some effort in learning Oracle, you will end up with nobody wanting to help you.
Re: Grant previlages [message #262543 is a reply to message #262436] Mon, 27 August 2007 07:53 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Once again, please go into another field. You have no technical skills whatsoever, and no skills to try something on your own. You have a learning disability, face it. How do you follow anything anyone ever tells you. How do you follow direction to get from one location to another? Jeez.

Can you please tell me what company would hire such a lazy clueless person such as yourself?

It is amazing that after 150 or so message that you still ask a question about how to grant a privilege. Do you know how to select from a table yet?

Please please just spare us all and stop this nonsense.

[Updated on: Mon, 27 August 2007 08:08]

Report message to a moderator

Previous Topic: Query To retrieve latest record
Next Topic: problem in union
Goto Forum:
  


Current Time: Tue Apr 23 16:29:50 CDT 2024