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-use...

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 <http://www.8451.com/>° 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 <https://www.facebook.com/8451group/?ref=aymt_homepage_panel> LinkedIn <https://www.linkedin.com/company/84-51/?trk=biz-companies-cym> Instagram <https://www.instagram.com/84.51/> Twitter <https://twitter.com/8451group> Please consider the environment before printing this email.

_______________________________________________ users-list mailing list users-list@monetdb.org <mailto:users-list@monetdb.org> https://www.monetdb.org/mailman/listinfo/users-list <https://www.monetdb.org/mailman/listinfo/users-list>