Currently, I’m using Dremio Software 24.3.2 version. I was using an admin account most of the time. But now to scale up, I have to create a new SQL account with specific privileges.
For example, now I need to create an account “userA” with the privilege to read the table “dbA.tableA”. It’s very simple in MySQL or SQL Server, but I’m having a headache when working with DremioSQL.
First, I create an account on the admin page
But there is no option to add role on privilege on the UI, so I have to use the query as doc below
Immediately gotan error like below
GRANT SELECT ON TABLE “hive_source.sapo_dw”.aggregatemerchantactivemonthlynew TO USER sapo_360;
java.lang.ClassNotFoundException: com.dremio.exec.planner.sql.handlers.CatalogGrantHandler
Try to check the Users and Privilege metadata, can’t find sys.users, sys.priviledge got permission error, even though I’m an admin
select * from sys.users;
SQL Error: VALIDATION ERROR: Object ‘users’ not found within ‘sys’. Please check that it exists in the selected context.
select * from sys.privileges;
SQL Error: SYSTEM ERROR: IllegalAccessException: Unable to retrieve sys.privileges.
In the doc, it said that sys db has these tables (version 24.3)
I’m so tired right now, why is it so simple in SQL Server/MySQL but it’s so hard in Dremio?