/****** Script for SelectTopNRows command from SSMS ******/ SELECT TOP 1000 convert(varchar,CONNECTIONPROPERTY('local_net_address'))AS IP,[SERVERNAME] ,[DATABASENAME] ,[ObjectName]AS [TABLE] ,[GRANTEE] AS [USER_NAME] ,[principal_type_desc] AS [USER_TYPE] ,[permission_name]AS [PERMISSION] FROM [KariyerMainDB].[dbo].[UserAuthentication] WHERE DatabaseName<>'KariyerMainDB' ORDER BY Grantee