DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: IS it possible --> Grant DROP Table to <username>/<role anme>;

  1. #1
    Join Date
    Dec 2005
    Posts
    19

    IS it possible --> Grant DROP Table to <username>/<role anme>;

    Can I give (9i/10g - DB):

    Grant DROP Table to /;

    I don't wan't to give
    Grant DROP any Table to /;

    Giving "any" will give the privledge to drop any table.


    Regards
    Arun Tayal

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    no, but you could create a stored prcoedure in your own schema which takes a tablename as a parameter, then you can give execute on that proc to whoever

  3. #3
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    can you give example davey
    thanks
    Behind The Success And Failure Of A Man Is A Woman

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    i could, but that would be doing peoples work for them. I;ll leave that as an exercise to the reader

  5. #5
    Join Date
    May 2005
    Location
    Boracay
    Posts
    681
    you are smart dear can i do it using a function too
    Behind The Success And Failure Of A Man Is A Woman

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