Home » RDBMS Server » Server Administration » To provide privilege on utlrp.sql to users (11g, 11.2.0.1, window server 2008)
To provide privilege on utlrp.sql to users [message #602620] Fri, 06 December 2013 01:06 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

Is it possible to provide access on UTLRP.sql to users. So that they don't require SYS password.

Waiting for your kind assistance..

Regards,
Ishika
Re: To provide privilege on utlrp.sql to users [message #602627 is a reply to message #602620] Fri, 06 December 2013 01:57 Go to previous messageGo to next message
Michel Cadot
Messages: 65317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

No but they can use DBMS_UTILITY.COMPILE_SCHEMA function to compile their objects.

Re: To provide privilege on utlrp.sql to users [message #602645 is a reply to message #602620] Fri, 06 December 2013 04:44 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
Actually utlrp.sql is a sql-file (in ?/rdbms/admin/) on the db-server.
So if your users can actually login in oracle on the server, they probably can access utlrp.sql, since they allready have a session on the server. (As opposed to connecting to the DB from your local machine)

This being said, the avarage use has not enough privileges to succesfully excecute the package.

I think that the solution Michel Cadot supplies is the right way to go.
Re: To provide privilege on utlrp.sql to users [message #602667 is a reply to message #602645] Fri, 06 December 2013 08:51 Go to previous messageGo to next message
gazzag
Messages: 907
Registered: November 2010
Location: Bristol, UK
Senior Member
You have to be SYS to run utlrp.sql. No user should be SYS.
Re: To provide privilege on utlrp.sql to users [message #602670 is a reply to message #602667] Fri, 06 December 2013 09:18 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
gazzag wrote on Fri, 06 December 2013 15:51
You have to be SYS to run utlrp.sql. No user should be SYS.

That's completly right, but I focused a little more on the first part of the question/sentence:
If you are on the system an you are logged on to oracle you can access the scripts in ?/rdbms/admin.

No special access needed.
Re: To provide privilege on utlrp.sql to users [message #602674 is a reply to message #602670] Fri, 06 December 2013 09:35 Go to previous message
gazzag
Messages: 907
Registered: November 2010
Location: Bristol, UK
Senior Member
Access to view the script is one thing. Privilege to run it is a completely different thing Smile
Previous Topic: Kick out users on 10g?
Next Topic: CPU_COUNT
Goto Forum:
  


Current Time: Fri Jan 19 23:57:10 CST 2018

Total time taken to generate the page: 0.01120 seconds