|
|
| Definitions More Info. | | Definition ID | 12.081 | | Title | SQL | | Category | NOTES | | Definition | login disable KAR | | 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 | 26-09-2022 11:11:45 | | Düzenle |  | | Kopyala |  | | Sil |  | | |
|
|