| set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider; |
| |
| -- SORT_BEFORE_DIFF |
| |
| CREATE DATABASE IF NOT EXISTS test_db COMMENT 'Hive test database'; |
| SHOW DATABASES; |
| |
| GRANT drop ON DATABASE test_db TO USER hive_test_user; |
| GRANT select ON DATABASE test_db TO USER hive_test_user; |
| |
| SHOW GRANT USER hive_test_user ON DATABASE test_db; |
| |
| CREATE ROLE db_TEST_Role; |
| GRANT ROLE db_TEST_Role TO USER hive_test_user; |
| SHOW ROLE GRANT USER hive_test_user; |
| |
| GRANT drop ON DATABASE test_db TO ROLE db_TEST_Role; |
| GRANT select ON DATABASE test_db TO ROLE db_TEST_Role; |
| |
| SHOW GRANT ROLE db_TEST_Role ON DATABASE test_db; |
| |
| DROP DATABASE IF EXISTS test_db; |