Execute privilege [message #448304] |
Mon, 22 March 2010 12:24  |
getritesh
Messages: 235 Registered: July 2006 Location: INDIA
|
Senior Member |

|
|
Hi,
Consider following scenario
Schema Update Privilege on emp directly
User1 Yes
User2 No
I have created a package named pack in user1 schema which contains one procedure which updates table emp.
Now i executed the following in schema user1
Grant execute on pack to user2;
I connected as user2 and executed
Create Synonym pack for user1.pack;
Note that user2 doesn't have update privileges on table emp
Please tell me whether user2 can update emp through package pack
Regards,
Ritesh
|
|
|
|
|
Re: Execute privilege [message #448307 is a reply to message #448305] |
Mon, 22 March 2010 12:29   |
getritesh
Messages: 235 Registered: July 2006 Location: INDIA
|
Senior Member |

|
|
Hi,
I cannot test it on home machine since it does have oracle installed, hence i'll be very thankful to u if u give me the answer
Regards,
Ritesh
|
|
|
|
Re: Execute privilege [message #448310 is a reply to message #448307] |
Mon, 22 March 2010 12:33   |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
getritesh wrote on Mon, 22 March 2010 12:29Hi,
I cannot test it on home machine since it does have oracle installed
Do you mean "does not?"
The obvious response to this is, "why not then install oracle on your home machine?"
|
|
|
|
Re: Execute privilege [message #448313 is a reply to message #448309] |
Mon, 22 March 2010 12:38   |
getritesh
Messages: 235 Registered: July 2006 Location: INDIA
|
Senior Member |

|
|
Hi,
I tried on oracle application express but there i was not allowes to create another user for testing purpose, it said
ORA-01031: insufficient privileges
when i tried to execute
create user user2 identified by t;
I tried but was not successful, so please answer my query as it is urgent
Regards,
Ritesh
|
|
|
|
|
|
Re: Execute privilege [message #448317 is a reply to message #448314] |
Mon, 22 March 2010 12:46   |
getritesh
Messages: 235 Registered: July 2006 Location: INDIA
|
Senior Member |

|
|
Hi,
I have created the package on user1 and it is going to be tested on client side in USA, they (client) are going to test my package on another schema and they want my suggestions as to how will test it on another schema
Regards,
Ritesh
|
|
|
|
|
|
|
|
|
Re: Execute privilege [message #449189 is a reply to message #448304] |
Sat, 27 March 2010 11:58  |
 |
Kevin Meade
Messages: 2103 Registered: December 1999 Location: Connecticut USA
|
Senior Member |
|
|
I sent an email to the OP. Either he/she did not get it, or they do not care enough to reply to us to show us they did the work we asked them to do.
Kevin
|
|
|