I have also noticed that dropping a table does not remove the associated privileges from the sys.privileges table. I assume this is a bug? On Mon, Dec 8, 2014 at 11:53 AM, Dennis Pallett wrote:

Hi all,

I'm playing around with the authorisation/privileges functionality in MonetDB and I'm wondering if it's possible to grant a user the SELECT privilege on ALL tables (present and future tables) in a schema?

At the moment I'm only able to grant this privilege on specific tables and I'd ideally like to create a user with full SELECT privileges and nothing more or less.

Best regards, Dennis