Symantec IT Risk and Compliance Product Group

 View Only

ESM query account permission for MSSQL 2012

  • 1.  ESM query account permission for MSSQL 2012

    Broadcom Employee
    Posted Mar 24, 2015 08:44 AM

    I refer to this pevious post:

    Following permissions are required explicitly on Sql Server 2005 and Sql Server 2008
    select master.sys.server_principals
    select master.sys.server_permissions
    select master.sys.databases
    select master.sys.configurations
    select master.sys.endpoints
    exec msdb.dbo.sp_help_proxy
    select sys.database_principals
    select sys.objects (for every database)
    select master.sys.databases
    select syscomments
    select sys.procedures
    select master.sys.sql_logins
    select master.sys.server_principals
    exec master..sp_helpsrvrole
    select serverproperty('productversion')
    select sys.objects
    select sys.sql_modules
    select sys.schemas
    select sys.objects

    Questions 1: Does this apply to MSSQL 2012?


    Question 2: How to do this? "select sys.objects (for every database)"


    Question 3: How to do this? "select serverproperty('productversion')"