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.
[cid:image001.jpg@01D64952.B2EE5CC0] Suresh Devarakonda 84.51http://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 Facebookhttps://www.facebook.com/8451group/?ref=aymt_homepage_panel LinkedInhttps://www.linkedin.com/company/84-51/?trk=biz-companies-cym Instagramhttps://www.instagram.com/84.51/ Twitterhttps://twitter.com/8451group Please consider the environment before printing this email.
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
participants (2)
-
Suresh Devarakonda
-
Ying Zhang