# 访问控制

##### <span style="color: rgb(0, 0, 0);">**<span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">测评项：</span><span lang="EN-US">a) </span><span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">应对登录的用户分配账户和权限；</span>**</span>

##### <span style="color: rgb(0, 0, 0);">**<span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">测评项：</span><span lang="EN-US">b) </span><span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">应重命名或删除默认账户，修改默认账户的默认口令；</span>**</span>

<p class="callout info"><span style="color: rgb(0, 0, 0);"><span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">云数据库不存在默认账户，安装在本地服务器上则注意root账户是否已修改口令。</span></span></p>

##### <span style="color: rgb(0, 0, 0);">**<span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">测评项：</span><span lang="EN-US">c) </span><span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">应及时删除或停用多余的、过期的账户，避免共享账户的存在；</span>**</span>

<p class="callout info"><span style="color: rgb(0, 0, 0);">多余/共享账户依据客户实际业务判定，但账户数小于3则强制判定共享账户。</span></p>

<p class="callout success"><span style="color: rgb(0, 0, 0);">通过访谈确定账户是否闲置；闲置账户处于锁定状态可视为不存在过期账户。</span></p>

```mysql
select Host,Account_locked,User,Insert_priv,Delete_priv,Alter_priv,Drop_priv,Grant_priv,Super_priv from mysql.user;
```

核查效果：

[![Snipaste_2025-08-01_11-11-35.png](https://document.nat.ac.cn/uploads/images/gallery/2025-08/scaled-1680-/snipaste-2025-08-01-11-11-35.png)](https://document.nat.ac.cn/uploads/images/gallery/2025-08/snipaste-2025-08-01-11-11-35.png)

---

##### **<span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">测评项：</span><span lang="EN-US">d) </span><span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">应授予管理用户所需的最小权限，实现管理用户的权限分离。</span>**

<p class="callout info"><span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">**<span style="font-family: 等线;">MySQL账户除日常使用的增删查改权限较为敏感外，针对等保场景须注意<span style="color: rgb(35, 111, 161);">Grant\_priv</span>和<span style="color: rgb(35, 111, 161);">Super\_priv</span>。前者可以扩展用户/数据库/数据库表的权限，后者可以管理所有的用户/数据库/数据库表。</span>**</span></p>

```mysql
select Host,Db,User,Insert_priv,Delete_priv,Alter_priv,Drop_priv,Grant_priv from mysql.db;
```

<span style="font-family: 等线;">[![Snipaste_2025-08-01_11-12-41.png](https://document.nat.ac.cn/uploads/images/gallery/2025-08/scaled-1680-/snipaste-2025-08-01-11-12-41.png)](https://document.nat.ac.cn/uploads/images/gallery/2025-08/snipaste-2025-08-01-11-12-41.png)</span>

---

##### **<span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">测评项：</span><span lang="EN-US">e</span><span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">）应由授权主体配置访问控制策略，访问控制策略规定主体对客体的访问规则；</span>**

<p class="callout info">**<span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">现场核查优先核查当前用户名所关联的权限，后续查看<span style="color: rgb(53, 152, 219);">mysql.role\_edges</span>表和<span style="color: rgb(53, 152, 219);">infomation\_schema.user\_privileges</span>表所包含的具体内容。当role\_edges表值为<span style="color: rgb(53, 152, 219);">空</span>时，缺省值为<span style="color: rgb(53, 152, 219);">root</span>。</span>**</p>

```
-- show grants for '用户名'@'数据库';
SELECT * FROM `role_edges`;
SELECT * FROM `USER_PRIVILEGES`;
```

[![Snipaste_2025-08-01_14-48-05.png](https://document.nat.ac.cn/uploads/images/gallery/2025-08/scaled-1680-/snipaste-2025-08-01-14-48-05.png)](https://document.nat.ac.cn/uploads/images/gallery/2025-08/snipaste-2025-08-01-14-48-05.png)[![Snipaste_2025-08-01_14-48-26.png](https://document.nat.ac.cn/uploads/images/gallery/2025-08/scaled-1680-/snipaste-2025-08-01-14-48-26.png)](https://document.nat.ac.cn/uploads/images/gallery/2025-08/snipaste-2025-08-01-14-48-26.png)

---

##### **<span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">测评项：</span><span lang="EN-US">f</span><span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">）访问控制的粒度应达到主体为用户级或进程级，客体为文件、数据库表级；</span>**

<p class="callout success">**<span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">数据库与用户间是一对多的关系，因此默认符合。</span>**</p>

---

##### **<span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">测评项：</span><span lang="EN-US">g</span><span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">）应对重要主体和客体设置安全标记，并控制主体对有安全标记信息资源的访问。</span>**

<p class="callout danger">**<span style="font-family: 等线; mso-ascii-font-family: Aptos; mso-ascii-theme-font: minor-latin; mso-fareast-theme-font: minor-fareast; mso-hansi-font-family: Aptos; mso-hansi-theme-font: minor-latin;">MySQL不支持等保场景的安全标记功能，须依赖第三方实现，因此默认不符合。</span>**</p>