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

Thread: truncate other user's tables

  1. #1
    Join Date
    Sep 2000
    Posts
    20
    i need a user to be able to truncate a couple of other user's tables.
    granting delete on those tables doesn't work. the only way i've found it works is granting drop any table to the user, but i don't find that safe. is there any other way??

  2. #2
    Join Date
    Feb 2001
    Posts
    184
    Oracle has given that way only.

    Drop any table gives the user ability to Truncate the Table in someone's Schema.

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Scenario: user A owns the tables to be truncated, user B should be able to truncate those tables without being granted "DROP ANY TABLE" privilege.

    I would recomend the following solution:

    1.) Let user A create a PL/SQL procedure that truncates the desired table(s) (using dynamic PL/SQL).
    2.) User A grants EXECUTE privilege on that procedure to user B

    User B is now able to truncate only those selected A's tables, not *any* table in the database.

    HTH,
    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