Home » Infrastructure » Unix » Privileges on Oracle_home (Oracle 10g 10.2.0.4.0, AIX 5.3)
Privileges on Oracle_home [message #523749] Tue, 20 September 2011 04:15 Go to next message
raj9999
Messages: 49
Registered: June 2011
Member
I am working with Oracle 10g 10.2.0.4.0 on AIX 5.3.

What Privileges are idle on ORACLE_HOME folder?
Kindly suggest...
Will giving 755 is ok?
Re: Privileges on Oracle_home [message #523752 is a reply to message #523749] Tue, 20 September 2011 04:22 Go to previous messageGo to next message
Michel Cadot
Messages: 58913
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is an idle privilege?

The default settings at Oracle installation are correct for most of the cases.

Regards
Michel
Re: Privileges on Oracle_home [message #523759 is a reply to message #523752] Tue, 20 September 2011 05:03 Go to previous messageGo to next message
raj9999
Messages: 49
Registered: June 2011
Member
Actually i have joined a new project & here it is set as 755.
So i want to know can i change it to 755 recursively?
Re: Privileges on Oracle_home [message #523760 is a reply to message #523759] Tue, 20 September 2011 05:10 Go to previous messageGo to next message
raj9999
Messages: 49
Registered: June 2011
Member
sactom wrote on Tue, 20 September 2011 15:33
Actually i have joined a new project & here it is set as 755.
So i want to know can i change it to 755 recursively?



Actually currently it is 777. sorry for the mistake in previous post.
Re: Privileges on Oracle_home [message #523765 is a reply to message #523760] Tue, 20 September 2011 05:31 Go to previous messageGo to next message
Michel Cadot
Messages: 58913
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
So i want to know can i change it to 755 recursively?

It depends if you use one or several accounts in dba group and why.

Regards
Michel
Re: Privileges on Oracle_home [message #523770 is a reply to message #523765] Tue, 20 September 2011 05:54 Go to previous messageGo to next message
raj9999
Messages: 49
Registered: June 2011
Member
There is only one user having dba privileges & for logging into the database from the db server.
Rest of the user login from the app server.

But there are some users which are there on the db server(which are not part of dba group). So if the privilges are 777 then anyone can delete any files.
I want to know whether changing it to 755 will have any impact from the application point of view?
Re: Privileges on Oracle_home [message #523775 is a reply to message #523770] Tue, 20 September 2011 06:56 Go to previous message
Michel Cadot
Messages: 58913
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So 755 is good.

Regards
Michel
Previous Topic: datafile rename
Next Topic: sftp multiple files
Goto Forum:
  


Current Time: Wed Aug 27 18:54:23 CDT 2014

Total time taken to generate the page: 0.10307 seconds