DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: insufficient privileges for sys?

  1. #1
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    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"

  2. #2
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    do not do alter session and then try.
    http://www.perf-engg.com
    A performance engineering forum

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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"

  4. #4
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    Is it a public D/B link.
    http://www.perf-engg.com
    A performance engineering forum

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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"

  6. #6
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    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.
    http://www.perf-engg.com
    A performance engineering forum

  7. #7
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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"

  8. #8
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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"

  9. #9
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    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...
    http://www.perf-engg.com
    A performance engineering forum

  10. #10
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    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
  •  


Click Here to Expand Forum to Full Width