Security of login

  • Hi All,

    I have a security very typical scenario. I have a SQL Server 2008.

    I have client which is having this wiered scenario.

    Basically, he wants to test View Server State permission so that he can access all the processes running on that particular instance.

    I tried the below and tried to reproduce the issue and am able to do it at my but it is not working on client instance.

    USE [master]

    GO

    CREATE LOGIN [testing] WITH PASSWORD=N'testing', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

    GO

    USE [db1]

    GO

    CREATE USER [testing] FOR LOGIN [testing]

    GO

    USE [db1]

    GO

    EXEC sp_addrolemember N'db_datareader', N'testing'

    GO

    --logged in a testing login and run below cmd

    select * from sys.sysprocesses

    /*

    spidkpidblockedwaittypewaittimelastwaittypewaitresourcedbiduidcpuphysical_iomemusagelogin_timelast_batchecidopen_transtatussidhostnameprogram_namehostprocesscmdnt_domainnt_usernamenet_addressnet_libraryloginamecontext_infosql_handlestmt_startstmt_endrequest_id

    54142800x00000SOS_SCHEDULER_YIELD 120022011-04-13 23:39:22.1402011-04-13 23:40:47.66000runnable 0x9CB24DF2069E4D4CADBCC972ABED53C600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000WIN-SERV Microsoft SQL Server Management Studio - Query 6116 SELECT 000FFEEE3A29LPC testing 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x01000100B0DAD51AF0B3E78B00000000000000000-10

    */

    -- checked the msdn link

    --As "sa" user now i have granted the

    use master

    go

    GRANT VIEW SERVER STATE to testing

    go

    -- As "testing" login, tried to access the sysprocesses. Am able to do that but on client instance we are not able to get all the process information.

    select * from sys.sysprocesses

    /*

    spidkpidblockedwaittypewaittimelastwaittypewaitresourcedbiduidcpuphysical_iomemusagelogin_timelast_batchecidopen_transtatussidhostnameprogram_namehostprocesscmdnt_domainnt_usernamenet_addressnet_libraryloginamecontext_infosql_handlestmt_startstmt_endrequest_id

    1238000x00000PREEMPTIVE_XE_CALLBACKEXECUTE 012506078002011-03-31 17:08:26.9702011-03-31 17:08:26.97000background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 RESOURCE MONITOR sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    2240000x015821345XE_TIMER_EVENT 010002011-03-31 17:08:26.9702011-03-31 17:08:26.97000background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 XE TIMER sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    3236400x015A430863300XE_DISPATCHER_WAIT 010002011-03-31 17:08:26.9702011-03-31 17:08:26.97000background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 XE DISPATCHER sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    4262400x0060769LAZYWRITER_SLEEP 0112760002011-03-31 17:08:26.9702011-03-31 17:08:26.97000background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 LAZY WRITER sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    5240400x007F14733LOGMGR_QUEUE 012340002011-03-31 17:08:26.9702011-03-31 17:08:26.97000background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 LOG WRITER sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    6262800x00801448REQUEST_FOR_DEADLOCK_SEARCH 01265002011-03-31 17:08:26.9702011-03-31 17:08:26.97000background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 LOCK MONITOR sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    7263200x009D1146837089KSOURCE_WAKEUP 110002011-03-31 17:08:26.9702011-03-31 17:08:26.97000background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 SIGNAL HANDLER sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    8000x00000MISCELLANEOUS 110002011-03-31 17:08:26.9702011-03-31 17:08:26.97000sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    9239600x00A23231SQLTRACE_INCREMENTAL_FLUSH_SLEEP 110002011-03-31 17:08:26.9702011-03-31 17:08:26.97000background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TRACE QUEUE TASK sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    10265200x0069923SLEEP_TASK 11265102011-03-31 17:08:26.9702011-03-31 17:08:26.97000background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 BRKR TASK sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    11263600x0081423827872CHECKPOINT_QUEUE 10148388402011-03-31 17:08:26.9702011-03-31 17:08:26.97000background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 CHECKPOINT sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    12264000x007E1146889947ONDEMAND_TASK_QUEUE 110002011-03-31 17:08:26.9702011-03-31 17:08:26.97000background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    13272000x00AE83495369BROKER_EVENTHANDLER 11462702011-03-31 17:08:26.9702011-03-31 17:08:26.97000background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 BRKR EVENT HNDLR sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    14000x00000MISCELLANEOUS 110002011-03-31 17:08:26.9702011-03-31 17:08:26.97000sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    15278400x00A91146880123BROKER_TRANSMITTER 110002011-03-31 17:08:26.9702011-03-31 17:08:26.97000background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 BRKR TASK sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    16264800x00A91146880123BROKER_TRANSMITTER 110002011-03-31 17:08:26.9702011-03-31 17:08:26.97000background 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 BRKR TASK sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    17000x00000MISCELLANEOUS 110002011-03-31 17:08:26.9702011-03-31 17:08:26.97000sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    18000x00000MISCELLANEOUS 110002011-03-31 17:08:26.9702011-03-31 17:08:26.97000sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    19000x00000MISCELLANEOUS 110002011-03-31 17:08:26.9702011-03-31 17:08:26.97000sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    20000x00000MISCELLANEOUS 110002011-03-31 17:08:26.9702011-03-31 17:08:26.97000sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    21000x00000MISCELLANEOUS 110002011-03-31 17:08:26.9702011-03-31 17:08:26.97000sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    22000x00000MISCELLANEOUS 110002011-03-31 17:08:26.9702011-03-31 17:08:26.97000sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    23000x00000MISCELLANEOUS 110002011-03-31 17:08:26.9702011-03-31 17:08:26.97000sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 TASK MANAGER sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0000000000000000000000000000000000000000000

    51000x00000MISCELLANEOUS 116406432011-04-09 00:51:36.7802011-04-13 23:38:43.50700sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000WIN-SERV Microsoft SQL Server Management Studio 6116 AWAITING COMMAND 000FFEEE3A29LPC sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x01000100EACCAE2A5069028C0000000000000000000

    52000x00000MISCELLANEOUS 1176422011-04-13 22:45:31.3172011-04-13 23:42:20.37300sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000WIN-SERV Microsoft SQL Server Management Studio - Query 6116 AWAITING COMMAND 000FFEEE3A29LPC sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x0100010064C3040580BAE78B0000000000000000000

    53000x00000MISCELLANEOUS 1246032011-04-13 23:38:56.7332011-04-13 23:38:59.04000sleeping 0x9CB24DF2069E4D4CADBCC972ABED53C600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000WIN-SERV Microsoft SQL Server Management Studio 6116 AWAITING COMMAND 000FFEEE3A29LPC testing 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x01000100E9630214A075028C0000000000000000000

    54652000x00000PREEMPTIVE_OS_WAITFORSINGLEOBJEC 1215022011-04-13 23:39:22.1402011-04-13 23:42:31.27000runnable 0x9CB24DF2069E4D4CADBCC972ABED53C600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000WIN-SERV Microsoft SQL Server Management Studio - Query 6116 SELECT 000FFEEE3A29LPC testing 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x010001007BFE2E1580BDE78B00000000000000000-10

    55000x00000MISCELLANEOUS 411563222011-04-07 15:35:00.0502011-04-07 18:36:01.11000sleeping 0x0101000000000005120000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000WIN-SERV SQLAgent - Generic Refresher 7376 AWAITING COMMANDNT AUTHORITY SYSTEM 000FFEEE3A29LPC NT AUTHORITY\SYSTEM 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x01000400EB08F51F606443860000000000000000000

    57000x00000MISCELLANEOUS 110022011-04-13 23:37:31.4872011-04-13 23:37:31.48700sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000WIN-SERV Microsoft SQL Server Management Studio - Query 6116 AWAITING COMMAND 000FFEEE3A29LPC sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x010001008F85BD000065028C0000000000000000000

    58000x00000MISCELLANEOUS 120022011-04-13 23:39:22.1672011-04-13 23:39:22.16700sleeping 0x9CB24DF2069E4D4CADBCC972ABED53C600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000WIN-SERV Microsoft SQL Server Management Studio - Query 6116 AWAITING COMMAND 000FFEEE3A29LPC testing 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x010001008F85BD000065028C0000000000000000000

    59000x00000MISCELLANEOUS 41151722011-04-07 18:27:43.8832011-04-07 18:27:44.63000sleeping 0x0100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000WIN-SERV Microsoft SQL Server Management Studio 6116 AWAITING COMMAND 000FFEEE3A29LPC sa 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x010004004F016F1410B56F850000000000000000000

    61000x00000MISCELLANEOUS 414618322011-04-08 00:00:00.6002011-04-13 02:00:00.63000sleeping 0x0101000000000005120000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000WIN-SERV SQLAgent - Job invocation engine 7376 AWAITING COMMANDNT AUTHORITY SYSTEM 000FFEEE3A29LPC NT AUTHORITY\SYSTEM 0x00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000x01000400EB08F51F606443860000000000000000000

    */

    -- This problem is specific to only single instances. On another instance, we are able to run like a CHARM.

    -- only on this instance it is behaving in this manner.

    I even tried to checking if there is any DENY PERMISSIONS using below query.

    -- Server level permissions

    SELECT ToWhom = grantee.name,

    WhoHasGiven = grantor.name,

    dp.class_desc,

    dp.permission_name,

    dp.state_desc,

    ObjectName = OBJECT_NAME(major_id)

    FROM sys.server_permissions dp

    JOIN

    sys.server_principals grantee on

    dp.grantee_principal_id = grantee.principal_id

    JOIN

    sys.server_principals grantor on

    dp.grantor_principal_id = grantor.principal_id

    order by grantee.name

    /*

    ToWhomWhoHasGivenclass_descpermission_namestate_descObjectName

    ##MS_AgentSigningCertificate##saSERVERCONNECT SQLGRANTNULL

    ##MS_PolicyEventProcessingLogin##saSERVERCONNECT SQLGRANTNULL

    ##MS_PolicySigningCertificate##saSERVERCONTROL SERVERGRANTNULL

    ##MS_PolicySigningCertificate##saSERVERVIEW ANY DEFINITIONGRANTNULL

    ##MS_SQLReplicationSigningCertificate##saSERVERVIEW ANY DEFINITIONGRANTNULL

    ##MS_SQLReplicationSigningCertificate##saSERVERVIEW SERVER STATEGRANTNULL

    ##MS_SQLResourceSigningCertificate##saSERVERVIEW ANY DEFINITIONGRANTNULL

    NT AUTHORITY\SYSTEMsaSERVERCONNECT SQLGRANTNULL

    publicsaSERVERVIEW ANY DATABASEGRANTNULL

    publicsaENDPOINTCONNECTGRANTNULL

    publicsaENDPOINTCONNECTGRANTsysrscols

    publicsaENDPOINTCONNECTGRANTNULL

    publicsaENDPOINTCONNECTGRANTsysrowsets

    ramsaSERVERCONNECT SQLGRANTNULL

    sasaSERVERCONNECT SQLGRANTNULL

    testingsaSERVERCONNECT SQLGRANTNULL

    testingsaSERVERVIEW SERVER STATEGRANTNULL

    */

    use db1

    go

    SELECT ToWhom = grantee.name,

    WhoHasGiven = grantor.name,

    dp.class_desc,

    dp.permission_name,

    dp.state_desc,

    ObjectName = OBJECT_NAME(major_id)

    FROM sys.database_permissions dp

    JOIN

    sys.database_principals grantee on

    dp.grantee_principal_id = grantee.principal_id

    JOIN

    sys.database_principals grantor on

    dp.grantor_principal_id = grantor.principal_id

    order by grantee.name

    Now my question is there anything we can check from "PUBLIC" role and "GUEST" user?

    But before that, i would like to know how the permissions will be inherited and want to an efficient

    way to check for the DENY and nail it from where it is getting inherited.

    Is there any set of queries by which we can nail it down?????

    I EVEN tried dropping and creating the LOGIN at his end. Still same issue....!!!

    This is really frustrating...!!!

    Now am not even able to repro his scenario at my end.

    Any help would be greatly appreciated.

    Thanks in advance.

  • Checked if DENY is coming from public role. even that is not working.

    Infact, if i try to grant VIEW SERVER STATE to public then it is working fine.

    Does anyone has comments on this issue?

    Thanks in Advance.

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

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