Pete Finnigan's Oracle Security Forum


    
      
        Pete Finnigan's Oracle Security Forum
        (http://www.petefinnigan.com/forum/yabb/YaBB.cgi)
      

        Oracle Security >> Oracle Security >> Which users can start and stop the listener
        
(Message started by: Pete Finnigan on Jan 18^th, 2012, 3:05pm)

Title: Which users can start and stop the listener
Post by Pete Finnigan on Jan 18^th, 2012, 3:05pm

Hello Pete,
I just have a quick question - which users can start and stop the listener?

Thanks!

Regards,
Thomas

Title: Re: Which users can start and stop the listener
Post by Pete Finnigan on Feb 6^th, 2012, 9:54am

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.

Title: Re: Which users can start and stop the listener
Post by Pete Finnigan on Feb 7^th, 2012, 4:35pm

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