Post reply

DBCC SQLPERF(LOGSPACE) and GRANT VIEW SERVER STATE

  • June 8, 2017 at 8:02 am

    #343105

    Granted domain user "VIEW SERVER STATE"

    GRANT VIEW SERVER STATE TO [mydoamin\reportuser]

    sql 2014
    user executed
    DBCC SQLPERF(LOGSPACE)
    result is only showing master, msdb, tempdb

    executed

    USE [testdb]

    CREATE USER [mydoamin\reportuser] FOR LOGIN [mydoamin\reportuser]

    as result  output has master, msdb, tempdb AND testdb
    according to BOL     DBCC SQLPERF(LOGSPACE)  need only VIEW SERVER STATE
    is it mistake in BOL ?

  • June 8, 2017 at 8:27 am

    #1946005

    Not necessarily incorrect as that is the permission needed to execute the command. What databases results they see with it is another issue which isn't clarified at all in BOL. They also need permissions to access to the database which would be either through the guest account or explicitly through their own account or group membership.

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply