CREATE DATABASE LINK privilege discussion
- From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 29 Oct 2011 10:20:02 -0500
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
Other related posts:
- » CREATE DATABASE LINK privilege discussion - Taylor, Chris David
- » RE: CREATE DATABASE LINK privilege discussion- Michael Dinh
- » RE: CREATE DATABASE LINK privilege discussion- Taylor, Chris David
- » RE: CREATE DATABASE LINK privilege discussion- Michael Dinh
- » RE: CREATE DATABASE LINK privilege discussion- David Robillard
- » Re: CREATE DATABASE LINK privilege discussion- Guillermo Alan Bort
- » Re: CREATE DATABASE LINK privilege discussion- Yechiel Adar
- » RE: CREATE DATABASE LINK privilege discussion- Taylor, Chris David
- » RE: CREATE DATABASE LINK privilege discussion- Taylor, Chris David
- » Re: CREATE DATABASE LINK privilege discussion- Bill Ferguson
- » RE: CREATE DATABASE LINK privilege discussion- Joel.Patterson
- » RE: CREATE DATABASE LINK privilege discussion- Taylor, Chris David
- » RE: CREATE DATABASE LINK privilege discussion- Storey, Robert (DCSO)
- » RE: CREATE DATABASE LINK privilege discussion- Joel.Patterson
- » RE: CREATE DATABASE LINK privilege discussion- Taylor, Chris David
- » Re: CREATE DATABASE LINK privilege discussion- David Robillard
- » Re: CREATE DATABASE LINK privilege discussion- Pete Finnigan
- » Re: CREATE DATABASE LINK privilege discussion- Subodh Deshpande
- » RE: CREATE DATABASE LINK privilege discussion- Joel.Patterson
- » RE: CREATE DATABASE LINK privilege discussion- Taylor, Chris David
- » RE: CREATE DATABASE LINK privilege discussion- Taylor, Chris David
- » RE: CREATE DATABASE LINK privilege discussion- Taylor, Chris David
- » RE: CREATE DATABASE LINK privilege discussion- Storey, Robert (DCSO)
- » RE: CREATE DATABASE LINK privilege discussion- John Hallas
- » RE: CREATE DATABASE LINK privilege discussion- David Robillard