# Have trouble while setting up new user account with priviledge on Dremio Software
**URL:** https://community.dremio.com/t/have-trouble-while-setting-up-new-user-account-with-priviledge-on-dremio-software/13051
**Category:** Uncategorized
**Created:** [June 16, 2025, 4:48am UTC](https://community.dremio.com/t/have-trouble-while-setting-up-new-user-account-with-priviledge-on-dremio-software/13051 "2025-06-16T04:48:33Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@quangbilly79](https://community.dremio.com/u/quangbilly79)
#### Post date: [June 16, 2025, 4:48am UTC](https://community.dremio.com/t/have-trouble-while-setting-up-new-user-account-with-priviledge-on-dremio-software/13051/1 "2025-06-16T04:48:33Z")
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
> **[Privileges | Dremio Documentation](https://docs.dremio.com/24.3.x/reference/sql/commands/rbac/)**
>
> The GRANT and REVOKE commands enable administrators to determine not only who receives what privilege, but also the scope or objects these privileges apply to.
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)
> **[System Tables | Dremio Documentation](https://docs.dremio.com/24.3.x/reference/sql/system-tables/)**
>
> System tables make up Dremio's system-created catalog to store metadata for the objects in your Dremio organization. Each system table is specific to the associated Dremio object and its attributes, unlike Information Schemas, which are based on the...
I’m so tired right now, why is it so simple in SQL Server/MySQL but it’s so hard in Dremio?
---
### Author:  [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [June 23, 2025, 4:45am UTC](https://community.dremio.com/t/have-trouble-while-setting-up-new-user-account-with-priviledge-on-dremio-software/13051/2 "2025-06-23T04:45:58Z")
@quangbilly79 RBAC is an Enterprise Edition feature
> **[Privileges | Dremio Documentation](https://docs.dremio.com/current/security/rbac/privileges/)**
>
> The following sections describe the supported privileges for each type of securable object.
---
### Author:  [@quangbilly79](https://community.dremio.com/u/quangbilly79)
#### Post date: [June 25, 2025, 2:19am UTC](https://community.dremio.com/t/have-trouble-while-setting-up-new-user-account-with-priviledge-on-dremio-software/13051/3 "2025-06-25T02:19:54Z")
@balaji.ramaswamy
Tks, but do you mean that a simple task like **granting read permission on table A to user A** is not possible in Dremio Software (free version), only available in the paid version? I mean, grant permission is a very basic feature that every DBMS has.
Maybe I’m misunderstanding. In that case, could you show me a **sample query** to grant permission to read table X for user Y?
I read the doc, but no example query makes me super confused
In SQL Server, it’s very simple like
GRANT SELECT ON SAPO\_DW.dbo.AggregateMerchantActiveDaily TO dungpv4;
Very simple query. I wonder what the Dremio Software query looks like.
Try Chat GPT, but no luck
---
### Author:  [@quangbilly79](https://community.dremio.com/u/quangbilly79)
#### Post date: [July 7, 2025, 8:53am UTC](https://community.dremio.com/t/have-trouble-while-setting-up-new-user-account-with-priviledge-on-dremio-software/13051/4 "2025-07-07T08:53:51Z")
Hi, I’m using Dremio Software with Hive catalog. Is it possible to Manage Permission? Just simple grant read permission on table X to person Y
---
### Author:  [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [July 14, 2025, 5:56am UTC](https://community.dremio.com/t/have-trouble-while-setting-up-new-user-account-with-priviledge-on-dremio-software/13051/5 "2025-07-14T05:56:38Z")
@quangbilly79 In CE version, every user is an admin