sp_updatestats permissions issue

• Raghavender Chavva

  SSCrazy Eights

  Points: 8669

  More actions

  June 19, 2019 at 10:25 am

  #3655178

  Hi All,

   

  while running sp_updatestats we are receiving permissions denied error.

  But as per below article, if we have db owner access on the database we can run this stored procedure.

  https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-updatestats-transact-sql?view=sql-server-2017

  But even we have db owner privileges on user databases we are getting permissions denied error.

  please let me know what is the workaround for this issue.

  Thank You.

  Regards,
  Raghavender Chavva

• DinoRS

  SSCrazy

  Points: 2683

  More actions

  June 19, 2019 at 12:54 pm

  #3655258

  There is no error, if you read the Documentation carefully, it clearly states that you have to be either sysadmin or DB-Owner (DBO) of the Database, the DBO is not equivalent to the db_owner role permission.