Auditing an Oracle database for security issues is very important. PeteFinnigan.com provides all of the information and tools that you will need Click here for details of PeteFinnigan.com Limited's detailed Oracle database security audit service Click here for details of PeteFinnigan.com Limited's Oracle Security Training Courses
Cookie Policy:We only use essential cookies on small sections of this website. For details see here.

Welcome, Guest. Please Login.
Nov 23rd, 2017, 7:06am
News: If you would like to register contact the forum admin
Home | Help | Search | Members | Login
   Pete Finnigan's Oracle Security Forum
   Oracle Security
   Oracle Security
(Moderator: Pete Finnigan)
   Which users can start and stop the listener
« Previous topic | Next topic »
Pages: 1  Reply | Notify of replies | Send Topic | Print
   Author  Topic: Which users can start and stop the listener  (Read 6299 times)
thoholm
PeteFinnigan.com Newbie
*





   
View Profile |

Gender: male
Posts: 2
Which users can start and stop the listener
« on: Jan 18th, 2012, 3:05pm »
Quote | Modify

Hello Pete,
I just have a quick question - which users can start and stop the listener?
 
Thanks!
 
Regards,
Thomas
IP Logged
Marcel-Jan
PeteFinnigan.com Junior Member
**






   
View Profile | WWW |

Gender: male
Posts: 83
Re: Which users can start and stop the listener
« Reply #1 on: Feb 6th, 2012, 9:54am »
Quote | Modify

Hi Thomas,
 
Sorry for the late answer.
In Unix Oracle processes like the listener are allowed to the dba group.
 
In Windows I'm not sure. You can start and stop the listener with the listener service, so if you're administrator that would probably suffice.  
 
I've been looking into the documentation, but I couldn't find anything else that quickly.
IP Logged
Pete Finnigan
PeteFinnigan.com Administrator
*****




Oracle Security is easier if you design for it

   
View Profile | WWW | Email

Gender: male
Posts: 309
Re: Which users can start and stop the listener
« Reply #2 on: Feb 7th, 2012, 4:35pm »
Quote | Modify

Hi Thom and Marcel-Jan,
 
The "dba" is sort of correct but it depends on what Unix group you have chosen for the OSDBA alias when you installed the Oracle software. It may be "dba" in most cases but maybe is not.  
 
In 9i you can stop and start the listener if you have privilege to run "lsnrctl" control tool. If in 9i or lower there is no password anyone can do it who can run the tool. If there is a password then anyone who can run the tool lsnrctl and has the password can do it. In 10g provided a password is not set an local authentication is not turned off then any user in the OSDBA group can manage the listener. In 11g the restriction is tightened to the user who started the listener can stoip the listener; so if you are in the OSDBA group and its not started you can start it then only you can stop it.  
 
hth
 
Pete
IP Logged

Pete Finnigan (email:pete@petefinnigan.com)
Oracle Security Web site: http://www.petefinnigan.com
Forum: http://www.petefinnigan.com/forum/yabb/YaBB.cgi
Oracle security blog: http://www.petefinnigan.com/weblog/entries/index.html
Pages: 1  Reply | Notify of replies | Send Topic | Print

« Previous topic | Next topic »

Powered by YaBB 1 Gold - SP 1.4!
Forum software copyright 2000-2004 Yet another Bulletin Board