You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by da...@apache.org on 2024/07/05 02:32:34 UTC
(doris) 04/10: [Fix](auth)add user cluster USAGE_PRIV in cloud mode (#37206)
This is an automated email from the ASF dual-hosted git repository.
dataroaring pushed a commit to branch branch-3.0
in repository https://gitbox.apache.org/repos/asf/doris.git
commit a8db924192f7515969a986be2375a3e0c6031a70
Author: zfr95 <87...@users.noreply.github.com>
AuthorDate: Thu Jul 4 10:55:05 2024 +0800
[Fix](auth)add user cluster USAGE_PRIV in cloud mode (#37206)
---
.../suites/auth_p0/test_master_slave_consistency_auth.groovy | 8 ++++++++
regression-test/suites/auth_p0/test_select_column_auth.groovy | 9 +++++++++
regression-test/suites/auth_up_down_p0/load.groovy | 8 ++++++++
3 files changed, 25 insertions(+)
diff --git a/regression-test/suites/auth_p0/test_master_slave_consistency_auth.groovy b/regression-test/suites/auth_p0/test_master_slave_consistency_auth.groovy
index 9e5239f6434..6c8f7e520b8 100644
--- a/regression-test/suites/auth_p0/test_master_slave_consistency_auth.groovy
+++ b/regression-test/suites/auth_p0/test_master_slave_consistency_auth.groovy
@@ -101,6 +101,14 @@ suite ("test_follower_consistent_auth","p0,auth") {
sql """refresh MATERIALIZED VIEW ${dbName}.${mtmv_name} auto"""
sql """grant select_priv on regression_test to ${user}"""
+ //cloud-mode
+ if (isCloudMode()) {
+ def clusters = sql " SHOW CLUSTERS; "
+ assertTrue(!clusters.isEmpty())
+ def validCluster = clusters[0][0]
+ sql """GRANT USAGE_PRIV ON CLUSTER ${validCluster} TO ${user}""";
+ }
+
connect(user=user, password="${pwd}", url=context.config.jdbcUrl) {
try {
diff --git a/regression-test/suites/auth_p0/test_select_column_auth.groovy b/regression-test/suites/auth_p0/test_select_column_auth.groovy
index 7e6cca7ce2d..2484eae5527 100644
--- a/regression-test/suites/auth_p0/test_select_column_auth.groovy
+++ b/regression-test/suites/auth_p0/test_select_column_auth.groovy
@@ -25,12 +25,21 @@ suite("test_select_column_auth","p0,auth") {
String view_name = 'test_select_column_auth_view'
String rollup_name = 'test_select_column_auth_rollup'
String catalog_name = 'test_select_column_auth_catalog'
+
try_sql("drop user ${user}")
try_sql """drop table if exists ${dbName}.${tableName}"""
sql """drop database if exists ${dbName}"""
sql """create user '${user}' IDENTIFIED by '${pwd}'"""
+ //cloud-mode
+ if (isCloudMode()) {
+ def clusters = sql " SHOW CLUSTERS; "
+ assertTrue(!clusters.isEmpty())
+ def validCluster = clusters[0][0]
+ sql """GRANT USAGE_PRIV ON CLUSTER ${validCluster} TO ${user}""";
+ }
+
sql """create database ${dbName}"""
sql """
CREATE TABLE IF NOT EXISTS ${dbName}.`${tableName}` (
diff --git a/regression-test/suites/auth_up_down_p0/load.groovy b/regression-test/suites/auth_up_down_p0/load.groovy
index fd1405e58e9..9a0d2b38d36 100644
--- a/regression-test/suites/auth_up_down_p0/load.groovy
+++ b/regression-test/suites/auth_up_down_p0/load.groovy
@@ -45,6 +45,14 @@ suite("test_upgrade_downgrade_prepare_auth","p0,auth") {
sql """CREATE ROLE ${role1}"""
sql """CREATE ROLE ${role2}"""
+ //cloud-mode
+ if (isCloudMode()) {
+ def clusters = sql " SHOW CLUSTERS; "
+ assertTrue(!clusters.isEmpty())
+ def validCluster = clusters[0][0]
+ sql """GRANT USAGE_PRIV ON CLUSTER ${validCluster} TO ${user1}""";
+ sql """GRANT USAGE_PRIV ON CLUSTER ${validCluster} TO ${user2}""";
+ }
try_sql """drop table if exists ${dbName}.${tableName1}"""
sql """drop database if exists ${dbName}"""
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org