-
truncate
Hi,
User A owns table temp_t .Is it possible to have user B truncate that table.
thanks,
-
If user 'B' has 'DROP ANY TABLE' priviledge, then user 'B' can truncate tables own by user 'A'
-
is it possible just to truncate that table without giving any system
prev..like drop any table
-
-
User A could create a stored procedure to truncate that table, and grant execute permission on it to users B, D, F, whoever.
Stored procedures created with DEFINER rights, rather than INVOKER rights, are an excellent way of controlling permissions in this way.
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
|