RE: Password for sys, system account - Uncooperative client

From: Smith, Ron L. <rlsmith_at_kmg.com>
Date: Thu, 9 Jun 2005 13:07:16 -0500
Message-ID: <270A0BDDFDE54E41B78F0F06D82A66B8013469A1@okcexg3.kmg.com>

LINK$
-----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 9: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

---

He has showed you, O man, what is good. And what does=20 the LORD require of you? To do justice and to love mercy=20 and to walk humbly with your God.=20
Micah 6:8

--

http://www.freelists.org/webpage/oracle-l

Important Notice!!
If you are not the intended recipient of this e-mail message, any use, = distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received = this message by mistake, then delete the e-mail message. Thank you.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 09 2005 - 14:12:47 CDT