Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

After enableing access control using ranger, the root user lack of privileges #45774

Open
VisionaryAries opened this issue May 17, 2024 · 0 comments
Labels
type/bug Something isn't working

Comments

@VisionaryAries
Copy link

StarRocks version is 3.3.0-rc1.

mysql> select current_version();
+--------------------+
| current_version()  |
+--------------------+
| 3.3.0-rc01-3b8cb0c |
+--------------------+
1 row in set (0.02 sec)

After enableing access control using ranger, the root user lack of privileges.

# mysql -h xx.xx.xx.xx -P 9030 -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.1.0 3.3.0-rc01-3b8cb0c

Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show roles;
ERROR 5204 (42000): Access denied; you need (at least one of) the GRANT privilege(s) on SYSTEM for this operation.
mysql> show databases;
Empty set (0.00 sec)
mysql> show catalogs;
+-----------------+----------+------------------------------------------------------------------+
| Catalog         | Type     | Comment                                                          |
+-----------------+----------+------------------------------------------------------------------+
| default_catalog | Internal | An internal catalog contains this cluster's self-managed tables. |
+-----------------+----------+------------------------------------------------------------------+
1 row in set (0.01 sec)

mysql> show databases from hive;
Empty set (1.15 sec)

mysql> show databases;
Empty set (0.00 sec)

mysql> show users;
ERROR 5204 (42000): Access denied; you need (at least one of) the GRANT privilege(s) on SYSTEM for this operation.
mysql> select * from mysql.users;
ERROR 5501 (3F000): Getting analyzing error. Detail message: Unknown database 'mysql'.
mysql> select current_version();
+--------------------+
| current_version()  |
+--------------------+
| 3.3.0-rc01-3b8cb0c |
+--------------------+
1 row in set (0.02 sec)
@VisionaryAries VisionaryAries added the type/bug Something isn't working label May 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
type/bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant