Hai, I don’t know the exact queries, but have you tried to create a new role, give this role access to the necessary system tables, and hand out this role to the relevant db users?

See also here: https://stackoverflow.com/questions/62599939/monetdb-how-to-create-a-new-user-role-to-have-full-access-to-the-entire-db-sch

On 23 Jun 2020, at 17:47, Suresh Devarakonda <Suresh.Devarakonda@8451.com> wrote:

Hi,
 
I just wanted to check if there is a way to grant access to system tables and views such as sys.tables and sys.schemas to the users other than granting “sysadmin” role.   I am not sure what kind of privileges the sysadmin role possess so would like to find if there are other roles or privileges available to access system tables and views. 
 
 
 
<image001.jpg>
Suresh Devarakonda
84.51°                            
TDO -  Database Support Team
D: 513.632.3692
M: 859.512.1839
A: 100 W. 5th Street, Cincinnati, Ohio 45202
 
Cincinnati  |  Chicago  |  New York  |  Portland 

Facebook    LinkedIn     Instagram     Twitter

Please consider the environment before printing this email.
 
 
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list