【 使用环境 】生产环境
【 OB 】
【 使用版本 】3.2.4
【问题描述】MySQL模式,通过obclient修改用户权限,领导要追责,怎么办?
【复现路径】问题出现前后相关操作,以下是日志 /home/admin/oceanbase/log/rootservice.log:
[2024-03-29 09:57:59.312091] INFO [SHARE.SCHEMA] ob_user_sql_service.cpp:766 [4507][0][YB42AC1000A5-00061259E07C13F3-0-0] [lt=8] [dc=0] gen_user_dml(is_ssl_support=false, user={tenant_id:1001, user_id:1100611139404781, user_name:"luke86", host_name:"%", privileges:"PRIV_ALTER,PRIV_CREATE,PRIV_DELETE,PRIV_DROP,PRIV_INSERT,PRIV_UPDATE,PRIV_SELECT", info:"", locked:false, ssl_type:0, ssl_cipher:"", x509_issuer:"", x509_subject:"", type:0, grantee_id_array:[], role_id_array:[], profile_id:18446744073709551615})
[2024-03-29 09:57:59.317160] INFO [SHARE.SCHEMA] ob_user_sql_service.cpp:766 [4507][0][YB42AC1000A5-00061259E07C13F3-0-0] [lt=8] [dc=0] gen_user_dml(is_ssl_support=false, user={tenant_id:1001, user_id:1100611139404781, user_name:"luke86", host_name:"%", privileges:"PRIV_ALTER,PRIV_CREATE,PRIV_DELETE,PRIV_DROP,PRIV_INSERT,PRIV_UPDATE,PRIV_SELECT", info:"", locked:false, ssl_type:0, ssl_cipher:"", x509_issuer:"", x509_subject:"", type:0, grantee_id_array:[], role_id_array:[], profile_id:18446744073709551615})
[2024-03-29 09:57:59.326785] INFO [SHARE.SCHEMA] ob_schema_retrieve_utils.ipp:2876 [4507][0][YB42AC1000A5-00061259E07C13F3-0-0] [lt=8] [dc=0] retrieve user schema succeed(schema={tenant_id:1001, user_id:1100611139404781, schema_version:1711677479312056, user_name:"luke86", host_name:"%", type:0})
[2024-03-29 09:57:59.326847] INFO [SHARE.SCHEMA] ob_schema_retrieve_utils.ipp:2876 [4507][0][YB42AC1000A5-00061259E07C13F3-0-0] [lt=8] [dc=0] retrieve all user schemas succeed(schema_array=[{tenant_id:1001, user_id:1100611139404781, schema_version:1711677479312056, user_name:"luke86", host_name:"%", type:0}])
[2024-03-29 09:57:59.327146] INFO [SHARE.SCHEMA] ob_server_schema_service.cpp:2661 [4507][0][YB42AC1000A5-00061259E07C13F3-0-0] [lt=1] [dc=0] add users finish(schemas=[{tenant_id:1001, user_id:1100611139404781, schema_version:1711677479312056, user_name:"luke86", host_name:"%", type:0}], ret=0)
[2024-03-29 09:57:59.327708] INFO [RS] ob_rs_rpc_processor.h:249 [4507][0][YB42AC1000A5-00061259E07C13F3-0-0] [lt=2] [dc=0] [DDL] execute ddl like stmt(ret=0, cost=19948, ddl_arg={ddl_stmt_str:"GRANT SELECT,INSERT,update,delete ON *.* TO luke86", exec_tenant_id:1001, ddl_id_str:"", is_replay_schema:false, based_schema_object_infos:[]})