Hi Sandy, Brian,

FYI, I have created a bug report for this issue, see

https://www.monetdb.org/bugzilla/show_bug.cgi?id=6388


The workaround is indeed (from a connection using user monetdb) running SQL commands:

grant select on sys.environment to voc;
grant select on sys.tables to voc;
grant select on sys.table_types to voc;


Thanks for reporting the issue.

regards,
Martin van Dinther


On 29-06-17 02:33, Sandy wrote:

Brian -

Executed this as monetdb user on the voc database -

grant all on sys.environment to voc;
grant all on sys.tables to voc;
grant all on sys.table_types to voc;

Not sure if `all` is needed or just `select` but I can try that.

Seems to now allow DBeaver and the SQuirreL SQL tools to pull the meta data now, inching forward ;)

Thanks again for the simple and obvious.

Sandy




On 6/24/2017 5:13 AM, Brian Hood wrote:
Hi Sandy,

Take a look at the permission documentation.

https://www.monetdb.org/Documentation/SQLreference/Permissions

Regards,

Brian Hood

On Sat, Jun 24, 2017 at 12:46 AM, Sandy <sandy@carlabs.com> wrote:
Just getting back into trying MonetDB after many years. Got the environment set up pretty well with the test DB `VOC` loaded up and able to do all expected in the command line tools. So I figured I would give a couple of the mentioned GUI tools a shot and see how they work against the server I just set up on a virtual box.

I picked up the JDBC drivers and installed on my Window's 10 install of SQuirrel SQL and DBeaver. I got both of the drivers works sort of... On DBeaver I can execute and see queries in the tool but can't do much more than that.

Overall looks like an issue with accessing the system table `sys.environment`,  not sure if anything related to set up or rights. Using the `voc` user as created with the example db in the getting started.  Any help or thought on where to start?

Thanks!

Sandy

-------- Errors

* DBeaver 4.0.8

On inspection of some of the logs I see things like -

`Error loading object metadata from database`

`SQL Error [22000]: SELECT: access denied for voc to table 'sys.environment'
  java.sql.SQLException: SELECT: access denied for voc to table 'sys.environment'`


* SQuirreL SQL Client  3.7.1

java.sql.SQLException: SELECT: access denied for voc to table 'sys.environment'


-------- Driver and DB versions

I'm using this JAR for the drivers - C:\Users\Squidward\Downloads\monetdb-jdbc-2.25.jar, 2.25 (Liberica 20170330 based on MCL v1.15)

MonetDB version - MonetDB v11.25.23 (Dec2016-SP5), 'mapi:monetdb://sandy-VirtualBox-18:50000/voc'




_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list



_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list

--
Sandy Ganz V.P. Engineering,
mobile:
address: 23480 Park Sorrento #100 | Calabasas, CA 91302 



_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list