Symantec IT Risk and Compliance Product Group

ESM query account permission for MSSQL 2012

  • 1.  ESM query account permission for MSSQL 2012

    Broadcom Employee
    Posted 03-24-2015 08:44 AM

    I refer to this pevious post: http://www.symantec.com/connect/forums/symantec-esm-modules-microsoft-sql-server-database-permissions

    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')
    master.sys.server_permissions
    master.sys.servers
    master.sys.configurations
    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')"

     

    Thanks!