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 <users-list-bounces+lcj34=cornell.edu@monetdb.org> on behalf of Lynn Carol Johnson <lcj34@cornell.edu>
Reply-To: Communication channel for MonetDB users <users-list@monetdb.org>
Date: Thursday, October 26, 2017 at 4:45 PM
To: Communication channel for MonetDB users <users-list@monetdb.org>
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 <table_name>

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 <table_name>” 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