Re: Grant access to sql system catalog

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

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