RE: CREATE DATABASE LINK privilege discussion

  • From: <Joel.Patterson@xxxxxxxxxxx>
  • To: <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 31 Oct 2011 14:51:45 -0400

Hmmm.  This implies that he needs 'real time' data.   But he is developing, and 
probably should be working off of 'refreshed' data, whenever that was... why 
can't it be old.   I wouldn't think that he has to have up to the minute data 
to develop.

Seems like there might be more going on here than development.  Maybe a little 
testing, verification .... something.   These databases normally are refreshed 
with data utilizing one method or another...   Everyone seems to want the 
latest data, normally these users run reports, but this is still dev.

The list seems to have formed a consensus around the issue, so you can take 
that to heart.

Joel Patterson
Database Administrator
904 727-2546

-----Original Message-----
From: Taylor, Chris David [mailto:ChrisDavid.Taylor@xxxxxxxxxxxxxxx] 
Sent: Monday, October 31, 2011 9:27 AM
To: Patterson, Joel; 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: CREATE DATABASE LINK privilege discussion

He's using a package in the dev database to query data from production to build 
result sets in the dev instance which have views built on top of them.

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205

"Quality is never an accident; it is always the result of intelligent effort."
-- John Ruskin (English Writer 1819-1900)

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and 
may also be privileged. If you are not the named recipient, please notify the 
sender immediately and delete the contents of this message without disclosing 
the contents to anyone, using them for any purpose, or storing or copying the 
information on any medium.


-----Original Message-----
From: Joel.Patterson@xxxxxxxxxxx [mailto:Joel.Patterson@xxxxxxxxxxx] 
Sent: Monday, October 31, 2011 8:24 AM
To: Taylor, Chris David; oracle-l@xxxxxxxxxxxxx
Subject: RE: CREATE DATABASE LINK privilege discussion

If he has the password, (hence creating link), then why not just log directly 
in?   Things would be faster and easier surely, I mean Shirley.

Joel Patterson
Database Administrator
904 727-2546

-----Original Message-----
From: Taylor, Chris David [mailto:ChrisDavid.Taylor@xxxxxxxxxxxxxxx] 
Sent: Monday, October 31, 2011 9:19 AM
To: Patterson, Joel; 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: CREATE DATABASE LINK privilege discussion

I *KNOW*.  It's killing me.

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205

"Quality is never an accident; it is always the result of intelligent effort."
-- John Ruskin (English Writer 1819-1900)

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and 
may also be privileged. If you are not the named recipient, please notify the 
sender immediately and delete the contents of this message without disclosing 
the contents to anyone, using them for any purpose, or storing or copying the 
information on any medium.


-----Original Message-----
From: Joel.Patterson@xxxxxxxxxxx [mailto:Joel.Patterson@xxxxxxxxxxx] 
Sent: Monday, October 31, 2011 7:56 AM
To: Taylor, Chris David; oracle-l@xxxxxxxxxxxxx
Subject: RE: CREATE DATABASE LINK privilege discussion

I cannot remember anyplace I have ever worked that did not have a policy 
against connecting to prod from any other database except another production 
database.    Sometimes production connects to dev/test/accp, but never the 
other direction.

Joel Patterson
Database Administrator
904 727-2546

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Taylor, Chris David
Sent: Saturday, October 29, 2011 11:20 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: CREATE DATABASE LINK privilege discussion

I am curious how many of you grant your developers the 'CREATE DATABASE LINK' 
privilege in 10g or higher?
We have a production read-only account that is setup to provide support for 
troubleshooting production support issues and one of my developers (out of 
approximately 20 devs) created a database link from a development database to 
production for his application.

Now, this is fast becoming an issue and he keeps complaining that he needs that 
privilege and that he should be able to create as many database links as he 
wants - wherever he wants (for those environments he has access to including 
the production support ID).

We (as an organization) have been sloppy in the past in granting 'CREATE 
DATABASE LINK' but thankfully we have developers who normally understand that 
you shouldn't use it to create links to a production support id for app dev.

So how do you handle it?  Is there a good document on what privs app devs 
should 'typically' have?  A good industry standards doc or some such?

Thanks,

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205

"Quality is never an accident; it is always the result of intelligent effort."
-- John Ruskin (English Writer 1819-1900)

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and 
may also be privileged. If you are not the named recipient, please notify the 
sender immediately and delete the contents of this message without disclosing 
the contents to anyone, using them for any purpose, or storing or copying the 
information on any medium.


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






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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2011