OraFAQ Forum: Unix » Privileges on Oracle

Home » Infrastructure » Unix » Privileges on Oracle_home (Oracle 10g 10.2.0.4.0, AIX 5.3)

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

Privileges on Oracle_home [message #523749]

Tue, 20 September 2011 04:15

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?

Report message to a moderator

Re: Privileges on Oracle_home [message #523752 is a reply to message #523749]

Tue, 20 September 2011 04:22

Michel Cadot
Messages: 68418
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

Report message to a moderator

Re: Privileges on Oracle_home [message #523759 is a reply to message #523752]

Tue, 20 September 2011 05:03

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?

Report message to a moderator

Re: Privileges on Oracle_home [message #523760 is a reply to message #523759]

Tue, 20 September 2011 05:10

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.

Report message to a moderator

Re: Privileges on Oracle_home [message #523765 is a reply to message #523760]

Tue, 20 September 2011 05:31

Michel Cadot
Messages: 68418
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

Report message to a moderator

Re: Privileges on Oracle_home [message #523770 is a reply to message #523765]

Tue, 20 September 2011 05:54

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?

Report message to a moderator

Re: Privileges on Oracle_home [message #523775 is a reply to message #523770]

Tue, 20 September 2011 06:56

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So 755 is good.

Regards
Michel

Report message to a moderator

Previous Topic:	datafile rename
Next Topic:	sftp multiple files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 27 17:48:07 CDT 2023