Printable View
I see one strange issue, sys not able to drop database link from different owner.. i wonder if am misssing something or is it a problem with oracle?
Code:CST7QST_ITF> show user
USER is "SYS"
CST7QST_ITF> alter session set current_schema = FIMT_AUDIT_TST;
Session altered.
Elapsed: 00:00:01.11
CST7QST_ITF> drop database link IMQ09ITF;
drop database link IMQ09ITF
*
ERROR at line 1:
ORA-01031: insufficient privileges
Elapsed: 00:00:01.41
CST7QST_ITF>
Rgds
Abhay.
do not do alter session and then try.
i had already done that.. and it will obiviously complain about non-existant database link.. as this one is private to the owner FIMT_AUDIT_TST
Is it a public D/B link.
now.. cant you see my sentence..
Quote:
as this one is private to the owner FIMT_AUDIT_TST
My fault..
But there are ways to point out mistakes.
This is one of the bad way to do that.
Well yea.. but if you see the error message cant you make it its clearly got to do with privilege issue..? and logically with the above error message you can conclude that there exists one such object... so the question of public/private should not come at all..
because if it were public, it would complain with no such database link (private) exists.. and not insufficient privelege.. you got to be logical to even judge/guess mistakes..
Now coming to the point, does any one know why oracle behaves strange with SYS (and system or any dba account) account when it comes to dropping others db links?
Do not question about some one's logical thinking by 1 ****in mistake...HTML Code:because if it were public, it would complain with no such database link (private) exists.. and not insufficient privelege.. you got to be logical to even judge/guess mistakes..
It maybe some body's bad day.
Any way it seems you want to argue. Come on man grow up...
thanks for the suggestion.. any ideas on the problem?
Oracle is not behaving strange, as per Oracle documentation this is what's supposed to happen.
Since there is not such a thing as DROP ANY DBLINK system privilege, private DBLINKs can be dropped only by the rightfull owner.
well yea.. but ..
Well just see what oracle does when you do drop user cascade.. it first tries to drop all objects and then actually remove the entry from user$.. now any user with DBA previlege can do this.. now my question is why should a user with DBA previlege not be able to do this operation?
Rgds
Abhay.
isnt it embrassing thing that sys gets "ORA-01031" while some operation?
Since this is a documented feature you should ask the question to Oracle, I'm pretty sure Angelo and crew will be delighted to deal with it.Quote:
Originally Posted by abhaysk