Post reply

Does DBCC LOGINFO require SysAdmin Rights.

  • September 28, 2015 at 5:07 am

    #303462

    Team,

    Can you please advice if DBCC LogInfo command require SysAdmin rights.

    With Thanks,

    Satnam

  • September 28, 2015 at 5:27 am

    #1829834

    basically, yes. you might be able to create a procedure featuring execute as owner,a nd grant an end user permissions to that, but thye cannot run dbcc themselves.

    here's an older set of permissions needed, it's not all inclusive, but you can see the pattern: server DBCC = sysadmin, database level requires dbowner, onyl a handful related to connection info are allowed for any user;

    --http://msdn.microsoft.com/en-us/library/aa258281(v=SQL.80).aspx

    DBCC Command Roles Required Caveat

    DBCC INPUTBUFFER sysadmin *users can run DBCC INPUTBUFFER against their own SPID

    DBCC SHRINKDATABASE sysadmin,db_owner

    DBCC CHECKALLOC sysadmin,db_owner

    DBCC CHECKCATALOG sysadmin,db_owner,db_backupoperator

    DBCC CHECKCONSTRAINTS sysadmin,db_owner

    DBCC CHECKDB sysadmin,db_owner

    DBCC CHECKFILEGROUP sysadmin,db_owner

    DBCC CHECKIDENT sysadmin,db_owner,db_ddladmin table owner can run DBCC CHECKIDENT

    DBCC CHECKTABLE sysadmin,db_owner table owner can run DBCC CHECKTABLE

    DBCC CLEANTABLE sysadmin,db_owner,db_ddladmin table owner can run DBCC CLEANTABLE

    DBCC CONCURRENCYVIOLATION sysadmin

    DBCC DBREPAIR deprecated use DROP DATABASE instead

    DBCC DBREINDEX sysadmin,db_owner,db_ddladmin table owner can run DBCC DBREINDEX

    DBCC dllname( FREE ) sysadmin,db_owner

    DBCC DROPCLEANBUFFERS sysadmin

    DBCC FREEPROCCACHE sysadmin,serveradmin

    DBCC HELP sysadmin

    DBCC INDEXDEFRAG sysadmin,db_owner,db_ddladmin table owner can run DBCC INDEXDEFRAG

    DBCC NEWALLOC deprecated identical to DBCC CHECKALLOC

    DBCC OPENTRAN sysadmin,db_owner

    DBCC OUTPUTBUFFER sysadmin

    DBCC PINTABLE sysadmin

    DBCC PROCCACHE sysadmin,db_owner

    DBCC ROWLOCK deprecated

    DBCC SHOWCONTIG sysadmin,db_owner,db_ddladmin table owner can run DBCC SHOWCONTIG

    DBCC SHOW_STATISTICS sysadmin,db_owner,db_ddladmin table owner can run DBCC SHOW_STATISTICS

    DBCC SHRINKDATABASE sysadmin,db_owner

    DBCC SHRINKFILE sysadmin,db_owner

    DBCC SHOWFILESTATS sysadmin,db_owner

    DBCC SQLPERF any user.

    DBCC TRACEOFF sysadmin

    DBCC TRACEON sysadmin

    DBCC TRACESTATUS any user.

    DBCC UNPINTABLE sysadmin

    DBCC UPDATEUSAGE sysadmin,db_owner

    DBCC USEROPTIONS any user.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • September 28, 2015 at 6:08 am

    #1829843

    No Information for DBCC LOGINFO.

    With Thanks,

    Satnam

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

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