Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Password for sys, system account - Uncooperative client
Because it subverts a security setting. See =
http://www.petefinnigan.com/weblog/archives/00000009.htm
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of John P Weatherman
Sent: Thursday, June 09, 2005 8:54 AM
To: oracle-l_at_freelists.org
Subject: RE: Password for sys, system account - Uncooperative client
While I totally agree that sys and system don't need to be given to =
anyone other than the primary DBA and then sealed in an envelope hidden = away in a safe, I am not so clear on why granting select any dictionary = is as big a concern. As far as I know, this only allows view access to =the data dictionary, which pretty much anyone doing any tuning or = monitoring probably needs. Even OEM assumes a non-sys/non-system = account with this level of privilege which is used for monitoring. Is = there a specific reason not to let people have select any dictionary? =20
Just curious.
-----Original Message-----
From: "Goulet, Dick" <DGoulet_at_vicr.com>
Sent: Jun 9, 2005 10:35 AM
To: ranko.mosic_at_gmail.com, oracle-l_at_freelists.org
Subject: RE: Password for sys, system account - Uncooperative client
Assuming that you made the request of the client using the same tone as here, I'm not surprised. Why do you need an account with such priviledges? In general NO one outside of the DBA group here has access to SYS or SYSTEM, including internal folks.
Dick Goulet
Senior Oracle DBA
Vicor Corporation
Andover, MA USA=3D20
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ranko Mosic
Sent: Thursday, June 09, 2005 10:27 AM
To: oracle-l_at_freelists.org
Subject: Password for sys, system account - Uncooperative client
Hi all,=3D3D20
I need password for account with select dictionary privileges - client
is=3D3D
=3D3D20
not too cooperative.=3D3D20
Regards, Ranko.
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 09 2005 - 11:05:26 CDT
![]() |
![]() |