sql permissions to run only update stats

Question

hi all,

we would like to give some business users with access to run only update stats.
I am thinking of creating a role for these users and somehow assign them the rights to run "update stats"
would you please share can I grant the users permisisons to run the sp_updatestats without them being in the sysasmin role.

thanks a lot for help

Answer 1

There's no granular permission for just UPDATE STATISTICS. Instead write a stored procedure to update the stats and give them EXECUTE permissions to the procedure.

eg:

create or alter procedure update_stats
with execute as owner
as
begin
   update statistics sometable with fullscan
end

Answer 2

Thank you very much.