Remind me why a user can drop a database link when they can't create one?

  • From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 27 Oct 2011 10:52:30 -0500

Apparently "DROP DATABASE LINK" doesn't exist as a privilege, so why can users 
still do it when they no longer have the right to "CREATE DATABASE LINK"?
Where does the drop database link security reside?

I wonder if there is a system login trigger I could employ to prevent the drop?

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205
Office: 615-517-3355
Cell: 615-663-1673
Email: chris.taylor@xxxxxxxxxxxxxxx<mailto:chris.taylor@xxxxxxxxxxxxxxx>

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: