Allowing user to shrink log file

[hedgracer]

I would like to allow a particular user to truncate a log file in a stored procedure that the user runs every day. At this moment the only personnel that can truncate the log file are personnel with sysadmin rights. Is there any way to do this in sql server 2005 without granting this user sysadmin rights (something we REALLY don't want to do)? Thanks for all your help in advance.

Dave C.

 

[SQLDenis]

the db_owner role should work

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[hedgracer]

Will using the db_owner role restrict the user to only being able to truncate the log file (not do anything else in maintenance and administration)?

Dave C.

 

[SQLDenis]

db_owner has all permissions in the database. So yes he can drop the db etc etc

how about creating a proc and using EXECUTE AS USER
and them just give them permissons to that proc

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions

 

[SQLDenis]

Here si the link to BOL

http://msdn2.microsoft.com/en-us/library/ms188354.aspx

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
Google Interview Questions