query sys.traces and select fn_trace_gettable

Resolution :

The sys.traces catalog view contains the current running traces on the system. This view is intended as a replacement for the fn_trace_getinfo function.function. Now to get access to sys.traces and sys.dm _exec_requests you need to grant user below permission by master user account.

I created a test user as below and executed the command it fails with a permission issue i.e. missing permission error:

USE [master] GO CREATE LOGIN [test1] WITH PASSWORD=N'XXXXX', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO

Now Grant the permissions as below to the user test1 then try to view the trace again.

GRANT ALTER TRACE TO test1