Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!news3.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!peer01.cox.net!cox.net!p01!fed1read12.POSTED!53ab2750!not-for-mail
Newsgroups: comp.databases.oracle.server
Subject: Re: Password protect DBA role
From: ianal Vista <ianal_vista@hotmail.com>
References: <1141419406.087347.133020@i39g2000cwa.googlegroups.com>
Message-ID: <Xns977BBFFC7977Bianalvistahotmailcom@70.169.32.36>
User-Agent: Xnews/5.04.25
Lines: 18
Date: Sat, 04 Mar 2006 02:53:03 GMT
NNTP-Posting-Host: 68.7.204.31
X-Complaints-To: abuse@cox.net
X-Trace: fed1read12 1141440783 68.7.204.31 (Fri, 03 Mar 2006 21:53:03 EST)
NNTP-Posting-Date: Fri, 03 Mar 2006 21:53:03 EST
Organization: Cox Communications
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:262775

aschexna@hotmail.com wrote in news:1141419406.087347.133020
@i39g2000cwa.googlegroups.com:

> I'm getting beat up by the Sar/Oxy auditors because the DBA role is not
> password protected. The only schemas that are granted this role are SYS
> and SYSTEM. I've tried to explain that the DBA is a default role for
> SYS and SYSTEM and setting a password is useless, but to no avail.
> 
> This is the 3rd company I've worked for as an Oracle DBA and I have
> never seen the DBA role password protected. Can anyone come up with a
> valid reason for password protecting the DBA role?
> 
> 

It may be a language problem, but I don't clearly understand the "problem".

Please provide an example of how any other role is "password" protected in 
Oracle.