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.
Aug 5th, 2020, 6:08pm
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)
   Kerberos login working but now can't login as sysd
« Previous topic | Next topic »
Pages: 1  Reply | Notify of replies | Send Topic | Print
   Author  Topic: Kerberos login working but now can't login as sysd  (Read 2268 times)
Pete Finnigan
PeteFinnigan.com Administrator
*****




Oracle Security is easier if you design for it

   
View Profile | WWW | Email

Gender: male
Posts: 309
Kerberos login working but now can't login as sysd
« on: Feb 19th, 2007, 6:31pm »
Quote | Modify

I finally got Kerberos authentication working using MS AD and OID. But now I can't login as sys (as sysdba) on the server presumably because it is trying to authenticate against OID where sys does not exist (nor will it ever). The only way I can login as sys is via DBVisualizer using JDBC (presumably because it doesn't attempt kerberos authentication). This is a problem not just because of sys but because of the plethora of system related logins that oracle expects to be available. Eventually after a day or two the database runs out of processes (presumably from its own failed housekeeping logins). Any suggestions?
Thanks, Dave.
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
Pete Finnigan
PeteFinnigan.com Administrator
*****




Oracle Security is easier if you design for it

   
View Profile | WWW | Email

Gender: male
Posts: 309
Re: Kerberos login working but now can't login as
« Reply #1 on: Feb 19th, 2007, 7:14pm »
Quote | Modify

To answer my own problem  Smiley
 
I had removed beq as an authentication service i.e. the line in sqlnet.ora should read:
SQLNET.AUTHENTICATION_SERVICES=(beq,kerberos5)
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