Monetdb team –
Any answer on this question? Do you expect non-admin users of monetdb to need access to sys.objects, sys.keys and sys.idxs in order to perform “select” statements on tables in user schema?
Thanks - Lynn
From: users-list on behalf of Lynn Carol Johnson
Reply-To: Communication channel for MonetDB users
Date: Thursday, October 26, 2017 at 4:45 PM
To: Communication channel for MonetDB users
Subject: latest version question
Hello monetdb team –
We upgraded this afternoon to the latest version of monetdb (Jul2017-SP2). When testing access for my lab, I noticed the general login could no longer perform the command:
\d
The errors were related to missing group access to sys.objects, sys.keys and sys.idxs. When, as monetdb admin, I granted “select” on these tables, the “\d ” command then worked.
Is this something new, or does it indicate a problem with the db ? It was not necessary to grant general users permission to these system tables previously.
Thanks - Lynn