none
minimum permissions in order to issue checkpoint and dropcleanbuffers RRS feed

  • Question

  • Hi we run 2017 standard.  What is the minimum permission(s) our dba needs to give me in order to run checkpoint followed by dbcc dropcleanbuffers on a dev server?  I have already read the do's and donts and have actually used dropcleanbuffers in the past at other sites.  I can already read tables etc on most of the db's on the targeted server.

    the error I get is

    Msg 2571, Level 14, State 1, Line 3

    User 'public' does not have permission to run DBCC DROPCLEANBUFFERS.

    • Edited by db042190 Tuesday, August 13, 2019 1:06 PM showing error
    Tuesday, August 13, 2019 12:42 PM

Answers

All replies

  • The required permissions are documented at MSDN
    CHECKPOINT => Security
    DBCC DROPCLEANBUFFERS => permissions

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by db042190 Wednesday, August 14, 2019 12:41 PM
    Tuesday, August 13, 2019 12:46 PM
    Moderator
  • thx. this is what is says, does the word fixed mean anything or is sysadmin the same as sysadmin fixed?

    Applies to: SQL Server, Parallel Data Warehouse

    • Requires membership in the sysadmin fixed server role.

    Tuesday, August 13, 2019 1:09 PM
  • thx. this is what is says, does the word fixed mean anything or is sysadmin the same as sysadmin fixed?

    Applies to: SQL Server, Parallel Data Warehouse

    • Requires membership in the sysadmin fixed server role.

    Hi, it is simply referring to the sysadmin server role.
    • Marked as answer by db042190 Wednesday, August 14, 2019 12:41 PM
    Tuesday, August 13, 2019 7:06 PM
  • Fixed role means here a predefined System Server role, which you can not modify.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, August 14, 2019 5:44 AM
    Moderator