Hi Using sys.queue is purely meant for DBMS system developers (e.g. monetdb root) and indeed very (!!) restrictive . The simple reason is that this provides a complete view of the concurrent queries and thus is a potential security risk. regards, Martin On 07/11/2018 18:14, Murthy, Gautham wrote:
Hello,
We are unable to get the information for all active users sessions when we use sys.queue as monetdb user.
Also, the tried as user other than monetdb, it returned no access, We had provided the user select privilege on the sys.queue view.
[monetadmin@lnx1487 scripts]$ /monet_binaries/MonetDB-11.27.13_PY/bin/mclient mapi:monetdb://lnx1487:50053/DB_BWS_S
Welcome to mclient, the MonetDB/SQL interactive terminal (Jul2017-SP4)
Database: MonetDB v11.27.13 (Jul2017-SP4), 'mapi:monetdb://lnx1487:50053/DB_BWS_S'
Type \q to quit, \? for a list of available commands
auto commit mode: on
sql>select "user","active",count(*) as "No. Of Connections" from sys.sessions() group by "user","active";
+-------------------+--------+--------------------+
| user | active | No. Of Connections |
+===================+========+====================+
| DM_POS_BWS_STG_P6 | true | 1 |
| DM_POS_BWS_STG_P6 | false | 3 |
| monetdb | true | 1 |
+-------------------+--------+--------------------+
3 tuples (6.027ms)
sql>select * from sys.queue;
+------+---------+----------------------------+----------------------------+----------+---------+--------+--------------------------+
| qtag | user | started | estimate | progress | status | tag | query |
+======+=========+============================+============================+==========+=========+========+==========================+
| 3630 | monetdb | 2018-11-07 17:07:34.000000 | null | null | running | 3630@0 | select * from sys.queue; |
+------+---------+----------------------------+----------------------------+----------+---------+--------+--------------------------+
1 tuple (1.610ms)
sql>\q
[monetadmin@lnx1487 scripts]$
Thank You,
Gautham
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list