-
insufficient privileges for sys?
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.
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
-
now.. cant you see my sentence..
as this one is private to the owner FIMT_AUDIT_TST
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
My fault..
But there are ways to point out mistakes.
This is one of the bad way to do that.
Last edited by malay_biswal; 12-28-2007 at 08:07 AM.
-
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..
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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?
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
-
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..
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...
-
thanks for the suggestion.. any ideas on the problem?
funky...
"I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."
"Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|