zddr commented on code in PR #17236:
URL: https://github.com/apache/doris/pull/17236#discussion_r1125776740
##########
regression-test/suites/account_p0/test_alter_user.groovy:
##########
@@ -17,32 +17,9 @@
suite("test_alter_user", "account") {
- sql """drop role if exists test_auth_role1"""
- sql """drop role if exists test_auth_role2"""
- sql """drop user if exists test_auth_user1"""
sql """drop user if exists test_auth_user2"""
sql """drop user if exists test_auth_user3"""
sql """drop user if exists test_auth_user4"""
-
- // 1. change user's default role
- sql """set global validate_password_policy=NONE"""
- sql """create role test_auth_role1"""
- sql """grant select_priv on db1.* to role 'test_auth_role1'"""
- sql """create role test_auth_role2"""
- sql """grant drop_priv on ctl.*.* to role 'test_auth_role2'"""
-
- sql """create user test_auth_user1 identified by '12345' default role
'test_auth_role1'"""
- order_qt_show_grants1 """show grants for 'test_auth_user1'"""
-
- sql """alter user test_auth_user1 default role 'test_auth_role2'"""
- order_qt_show_grants2 """show grants for 'test_auth_user1'"""
-
- sql """grant load_priv on ctl.*.* to test_auth_user1"""
- sql """grant load_priv on ctl.*.* to role 'test_auth_role2'"""
-
- // change user's role again
- sql """alter user test_auth_user1 default role 'test_auth_role1'"""
- order_qt_show_grants3 """show grants for 'test_auth_user1'"""
// 2. test password history
sql """set global password_history=0""" // disabled
Review Comment:
Corresponding use cases have been added to fe ut
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
