locked
sp_updatestats - User does not have permission to perform this action RRS feed

  • Question

  • According to

    http://msdn.microsoft.com/en-us/library/ms173804(v=sql.110).aspx

    Permissions
    --------------------------------------------------------------------------------
     
    Requires membership in the sysadmin fixed server role, or ownership of the database (dbo).
    

    the security context within which sp_updatestats is being executed can be sysadmin server role OR "ownership of the database (dbo)".  By "ownership of the database (dbo)" would that include anyone who has the db_owner database role membership?


    May we all make money in the sequel.

    Thursday, June 5, 2014 2:55 PM

Answers

  • No, you can execute sp_updates only if you are the actual owner of the database

    Its a bug

    http://microsoft.public.sqlserver.programming.narkive.com/VMUuTq0i/bug-in-sp-updatestats

    you can try a workaround in the below link

    http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=436562

    --Prashanth


    Thursday, June 5, 2014 5:06 PM

All replies

  • No, you can execute sp_updates only if you are the actual owner of the database

    Its a bug

    http://microsoft.public.sqlserver.programming.narkive.com/VMUuTq0i/bug-in-sp-updatestats

    you can try a workaround in the below link

    http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=436562

    --Prashanth


    Thursday, June 5, 2014 5:06 PM
  • Thanks.  It appears to exist in version 11.0.3000.0 as well.

    May we all make money in the sequel.

    Thursday, June 5, 2014 5:57 PM