OraFAQ Forum: Server Administration » To provide privilege on utlrp.sql to users

Home » RDBMS Server » Server Administration » To provide privilege on utlrp.sql to users (11g, 11.2.0.1, window server 2008)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

To provide privilege on utlrp.sql to users [message #602620]

Fri, 06 December 2013 01:06

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

Report message to a moderator

Re: To provide privilege on utlrp.sql to users [message #602627 is a reply to message #602620]

Fri, 06 December 2013 01:57

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: To provide privilege on utlrp.sql to users [message #602645 is a reply to message #602620]

Fri, 06 December 2013 04:44

martijn
Messages: 286
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.

Report message to a moderator

Re: To provide privilege on utlrp.sql to users [message #602667 is a reply to message #602645]

Fri, 06 December 2013 08:51

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

You have to be SYS to run utlrp.sql. No user should be SYS.

Report message to a moderator

Re: To provide privilege on utlrp.sql to users [message #602670 is a reply to message #602667]

Fri, 06 December 2013 09:18

martijn
Messages: 286
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.

Report message to a moderator

Re: To provide privilege on utlrp.sql to users [message #602674 is a reply to message #602670]

Fri, 06 December 2013 09:35

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Access to view the script is one thing. Privilege to run it is a completely different thing Smile

Report message to a moderator

Previous Topic:	Kick out users on 10g?
Next Topic:	CPU_COUNT

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 23:51:14 CST 2024