DEFINITIONS

Definitions More Info.
Definition ID321
TitleSQL
CategorySCRIPT
DefinitionUSER INFORMATIONS BILGILERI
Definition Description/****** 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
RecordBycunay
Record Date15-05-2013 14:40:43
Düzenle
Kopyala
Sil