insufficient privileges for sys?

[abhaysk]

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?

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.

[malay_biswal]

do not do alter session and then try.

[abhaysk]

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

[malay_biswal]

Is it a public D/B link.

[abhaysk]

now.. cant you see my sentence..

as this one is private to the owner FIMT_AUDIT_TST

[malay_biswal]

My fault..
But there are ways to point out mistakes.
This is one of the bad way to do that.

[abhaysk]

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..

[abhaysk]

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?

[malay_biswal]

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..

Do not question about some one's logical thinking by 1 ****in mistake...
It maybe some body's bad day.
Any way it seems you want to argue. Come on man grow up...

[abhaysk]

thanks for the suggestion.. any ideas on the problem?