It *must* be....I'd have to check. 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. From: TESTAJ3@xxxxxxxxxxxxxx [mailto:TESTAJ3@xxxxxxxxxxxxxx] Sent: Thursday, October 27, 2011 10:58 AM To: Taylor, Chris David Cc: 'oracle-l@xxxxxxxxxxxxx'; oracle-l-bounce@xxxxxxxxxxxxx Subject: Re: Remind me why a user can drop a database link when they can't create one? i thought it was implied if you own it, you can drop it. joe [cid:image001.jpg@01CC949A.6AE10CF0] From: "Taylor, Chris David" <ChrisDavid.Taylor@xxxxxxxxxxxxxxx> To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx> Date: 10/27/2011 11:54 AM Subject: Remind me why a user can drop a database link when they can't create one? Sent by: oracle-l-bounce@xxxxxxxxxxxxx ________________________________ 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 -- //www.freelists.org/webpage/oracle-l