【测试类型：工具功能】【测试版本：7.0.0-RC1】gs_checkse工具检测指定数据库。B5修复成功后应不打印报错信息

【标题描述】: gs_checkse工具检测指定数据库。B5修复成功后应不打印报错信息
【测试类型：工具功能】【测试版本：7.0.0-RC1】 问题描述：gs_checkse工具检测指定数据库。B5修复成功后应不打印报错信息

【操作系统和硬件信息】(查询命令: cat /etc/system-release, uname -a):
openEuler release 22.03 LTS
Linux openeuler-22 5.10.0-60.139.0.166.oe2203.x86_64 #1 SMP Thu May 30 05:17:57 UTC 2024 x86_64 x86_64 x86_64 GNU/Linux

【测试环境】(单机/1主x备x级联备):
单机

【被测功能】:
gs_checkse

【测试类型】:
功能测试

【数据库版本】(查询命令: gaussdb -V):
gaussdb (openGauss 7.0.0-RC1 build 665cb8b1) compiled at 2024-10-14 00:45:37 commit 0 last mr

【预置条件】:
om安装数据库成功

【操作步骤】(请填写详细的操作步骤):
1. 增加参数可以指定对应的库检测

```
gsql -d testdb -p 61526  -c "GRANT ALL PRIVILEGES ON pg_authid TO PUBLIC;"
GRANT
[lhj@openeuler-22 server]$
[lhj@openeuler-22 server]$ gs_checkse -i A5 --detail
Checking items
    A5. [ Permission management ]                               : Normal
        Checking Permission management succeeded.
Total numbers:1. Abnormal numbers:0. Warning numbers:0.
[lhj@openeuler-22 server]$ gsql -d postgres -p 61526  -c "GRANT ALL PRIVILEGES ON pg_authid TO PUBLIC;"
GRANT
[lhj@openeuler-22 server]$ gs_checkse -i A5 --detail
Checking items
    A5. [ Permission management ]                               : Warning
        [openeuler-22]
        Warning reason: Prohibit the PUBLIC role from having permissions on the pg_authid system table.Since all users inherit the permissions of the PUBLIC role, to prevent sensitiv                          e information from being leaked or altered, the PUBLIC role is not allowed to have any permissions on the pg_authid system table.
        Warning reason:Disallow granting all privileges on objects to the PUBLIC role.The PUBLIC role belongs to any user, and if all permissions of an object are granted to the PUBL                          IC role, then any user will inherit all permissions of this object, which violates the principle of least privilege. To ensure the security of database data, this role should have as                           few permissions as possible, and it is prohibited to grant all permissions of an object to the PUBLIC role.

Total numbers:1. Abnormal numbers:0. Warning numbers:1.

```

2. B5修复后打印了报错信息

```
openGauss=# CREATE user lily WITH CREATEROLE PASSWORD "qwer*963.";
CREATE ROLE
openGauss=#  SELECT rolname FROM pg_roles WHERE rolcreaterole = true AND rolsuper = false;
 rolname
---------
 lily
(1 row)
[lhj@openeuler-22 server]$ gs_checkse -i A5 --detail
Checking items
    A5. [ Permission management ]                               : Warning
        [openeuler-22]
        Warning reason:Ensure revocation of unnecessary administrative privileges from regular users.As a regular user, they should not possess administrative permissions beyond thei                          r normal scope. To ensure that the permissions of regular users are minimized while meeting normal business needs, unnecessary administrative permissions for regular users should be                           revoked.
[lhj@openeuler-22 server]$ gs_checkse -i B5 --detail
        [openeuler-22]:
[GAUSS-51632] : Failed to do python3 '/data/lhj/6.0.0master/tool/script/local/LocalCheckSE.py' -t Set_Permission_management -l '/data/lhj/6.0.0master/log/lhj/lhj/om/gs_local.log' . E                          rror:
'list' object has no attribute 'errormsg'
[lhj@openeuler-22 server]$ gsql -d postgres -p 61526  -r
gsql ((openGauss 7.0.0-RC1 build 665cb8b1) compiled at 2024-10-14 00:45:37 commit 0 last mr  )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

openGauss=# SELECT rolname FROM pg_roles WHERE rolcreaterole = true AND rolsuper = false;
 rolname
---------
(0 rows)

```

【预期输出】:
1. 增加参数可以指定对应的库检测
2. 用户具有创建角色的权限，进行修复gs_checkse -i B5 --detail不报错

【实际输出】:
1. 不能指定库检测
2. 用户具有创建角色的权限，进行修复gs_checkse -i B5 --detail报错
![输入图片说明](https://foruda.gitee.com/images/1730187322819435933/8c29c5eb_10825457.png "屏幕截图")

【原因分析】:
1. 这个问题的根因
2. 问题推断过程
3. 还有哪些原因可能造成类似现象
4. 该问题是否有临时规避措施
5. 问题解决方案
6. 预计修复问题时间

【日志信息】(请附上日志文件、截图、coredump信息):

【测试代码】:

openGauss/openGauss-OM

内容风险标识

评论 (3)

openGauss/openGauss-OM .gitee-modal { width: 500px !important; }

内容风险标识