# Can't add permission to access table after create table on NOCODB

**URL:** <https://community.nocodb.com/t/cant-add-permission-to-access-table-after-create-table-on-nocodb/1034>\
**Category:** Discord-Discussions\
**Created:** [February 2, 2024, 11:12am UTC](https://community.nocodb.com/t/cant-add-permission-to-access-table-after-create-table-on-nocodb/1034 "2024-02-02T11:12:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nonewja063](https://avatars.discourse-cdn.com/v4/letter/n/48db29/32.png) [@nonewja063](https://community.nocodb.com/u/nonewja063)\
**Post date:** [February 2, 2024, 11:12am UTC](https://community.nocodb.com/t/cant-add-permission-to-access-table-after-create-table-on-nocodb/1034/1 "2024-02-02T11:12:27Z")

</div>

I create new schema = ‘audit\_custom’  
create table on NOCODB table name = ‘table\_test\_2’  
and grant privilege USAGE , CREATE to user ‘nocodb\_user’

but can’t add permission to ‘admin\_user’ access to table ‘table\_test\_2’  
i get error this \>\>\> SQL Error [42501]: ERROR: permission denied for table table\_test\_2  
and query in picture not show table name = ‘table\_test\_2’  
 ![Screenshot 2024-02-02 180910111](https://canada1.discourse-cdn.com/flex011/uploads/nocodb/original/1X/55227dcc8d759dd919dc33bda6d21a5d9b8a9abc.png)

how i can add permission user ‘admin\_user’ to select data ?

---

<div class="post-metadata">

**Author:** ![pranavxc](https://avatars.discourse-cdn.com/v4/letter/p/53a042/32.png) [@pranavxc](https://community.nocodb.com/u/pranavxc)\
**Post date:** [February 10, 2024, 5:40am UTC](https://community.nocodb.com/t/cant-add-permission-to-access-table-after-create-table-on-nocodb/1034/2 "2024-02-10T05:40:05Z")

</div>

> [@nonewja063](#):
>
> but can’t add permission to ‘admin\_user’ access to table ‘table\_test\_2’  
> i get error this \>\>\> SQL Error [42501]: ERROR: permission denied for table table\_test\_2  
> and query in picture not show table name = ‘table\_test\_2’

It completely depends on the database you are using.

Mysql - [https://dev.mysql.com/doc/refman/8.0/en/account-management-statements.html](https://dev.mysql.com/doc/refman/8.0/en/account-management-statements.html)  
Postgres - [PostgreSQL: Documentation: 9.1: GRANT](https://www.postgresql.org/docs/9.1/sql-grant.html) [PostgreSQL: Documentation: 16: createuser](https://www.postgresql.org/docs/current/app-createuser.html)