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

Thread: Privilege that are needed!!

  1. #1
    Join Date
    Feb 2001
    Posts
    119

    Privilege that are needed!!

    scott user has lots of Procedure/Packages and Package Bodies.

    As an user I want to see the Procedure/Packages and Package Bodies of scott,
    debug,alter and compile them.What are the privs that need to be given.

    Thanks

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Alter any procedure & execute any procedure. Be careful, this is not a recommeded practice.

    Thanx,
    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Feb 2001
    Posts
    119
    From the system user I have Granted the alter any procedure & execute any procedure .

    I logged out and Logged in my schema.But still I am not able to see Scott's ...Procedure and Packages using the Toad...

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    How are you trying to check through toadd
    Thanx
    Sam



    Life is a journey, not a destination!


  5. #5
    Join Date
    Feb 2001
    Posts
    119
    I am Logging with the userid Subha ,select the scott user(from the dropdown menu) and Looking for the Procedure and Packages ...

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    you must of done something wrong then as it works for me here

  7. #7
    Join Date
    Feb 2001
    Posts
    119
    SQL> select * from session_privs ;

    PRIVILEGE
    ----------------------------------------
    ALTER SYSTEM
    CREATE SESSION
    ALTER SESSION
    DROP ANY TABLE
    SELECT ANY TABLE
    INSERT ANY TABLE
    UPDATE ANY TABLE
    DELETE ANY TABLE
    CREATE VIEW
    CREATE ANY VIEW
    DROP ANY VIEW
    SELECT ANY SEQUENCE
    ALTER ANY PROCEDURE
    EXECUTE ANY PROCEDURE

    14 rows selected.

  8. #8
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Can you compile or debug or execute the scott's package from sqlplus. Remember to qualify with the schema name i.e scott

    If you encounter any error, please remeber to include them too on the post.
    Thanx
    Sam



    Life is a journey, not a destination!


  9. #9
    Join Date
    Feb 2001
    Posts
    119
    I can do everything in Procedure and packages.But Package Bodies I am not able to see .....

  10. #10
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Quote Originally Posted by Subha
    I can do everything in Procedure and packages.But Package Bodies I am not able to see .....
    GRANT SELECT ANY DICTIONARY TO .....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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