|
|
| Definitions More Info. | | Definition ID | 12.091 | | Title | SQL | | Category | NOTES | | Definition | login user list sorgusu | | Definition Description | SELECT 'ALTER LOGIN ['+spri.name+'] DISABLE',sper.permission_name
FROM
sys.server_permissions sper
INNER JOIN sys.server_principals spri ON
sper.grantee_principal_id = spri.principal_id
WHERE name NOT IN ('sa',
'public',
'##MS_SQLResourceSigningCertificate##',
'##MS_SQLReplicationSigningCertificate##',
'##MS_SQLReplicationSigningCertificate##',
'##MS_SQLReplicationSigningCertificate##',
'##MS_SQLAuthenticatorCertificate##',
'##MS_PolicySigningCertificate##',
'##MS_PolicySigningCertificate##',
'##MS_SmoExtendedSigningCertificate##',
'##MS_PolicyTsqlExecutionLogin##',
'##MS_PolicyTsqlExecutionLogin##',
'##MS_PolicyTsqlExecutionLogin##',
'KNSPACE\sqladmin',
'NT SERVICE\SQLWriter',
'NT SERVICE\Winmgmt',
'NT SERVICE\MSSQLSERVER',
'NT AUTHORITY\SYSTEM',
'NT AUTHORITY\SYSTEM',
'NT AUTHORITY\SYSTEM',
'NT SERVICE\SQLSERVERAGENT',
'NT SERVICE\SQLTELEMETRY',
'NT SERVICE\SQLTELEMETRY',
'NT SERVICE\SQLTELEMETRY',
'NT SERVICE\SQLTELEMETRY',
'NT SERVICE\SQLTELEMETRY',
'sqladmin',
'##MS_PolicyEventProcessingLogin##',
'##MS_AgentSigningCertificate##')
| | RecordBy | cunay | | Record Date | 01-12-2022 13:23:31 | | Düzenle |  | | Kopyala |  | | Sil |  | | |
|
|