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

[nonewja063]

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’

how i can add permission user ‘admin_user’ to select data ?

[pranavxc]

@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
Postgres - PostgreSQL: Documentation: 9.1: GRANT PostgreSQL: Documentation: 16: createuser