Hi All,

Exactly what priviliges does an ordinary user need to run queries on imadb?

I've read the manual and can't find anything specific but although the users can access imadb and can execute queries with no error ... they get no data.

As an example, I have written a program for them which traces the locks they have taken in an application.
The program connects to imadb and after updating ima_mib_objects to look atall servers in the installation it executes:

select
ll.locklist_session_id,
ss.db_name, ss.effective_user, ss.real_user,
lt.tx_transaction_id,
l.lock_request_mode,
l.lock_state,
r.resource_key
from
ima_locks l join ima_locklists ll
on l.vnode = ll.vnode and l.locklist_id = ll.locklist_id
join ima_resources r
on l.vnode = r.vnode and l.resource_id = r.resource_id
join ima_server_sessions ss
on ll.locklist_session_id = ss.session_id
and ll.locklist_server_pid = ss.server_pid
join ima_log_transactions lt
on ss.server_pid = lt.tx_server_pid
and ss.session_id = lt.tx_session_id

This query will return rows when I execute it as user ingres (and there is something to report), but it will never return rows when run by any other user.

Martin Bowes

Hi Marty,

You need security administrator. The same applies to imp which is a
pity because it would be useful for our developers otherwise.

Jeremy


--
jruffer

Thnaks Jeremy, that did the trick.

Marty

-----Original Message-----
From: Ingres Forums [mailto:info-ingres (AT) kettleriverconsulting (DOT) com]
Sent: 05 October 2011 11:21
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: Re: [Info-Ingres] imadb privilges


Hi Marty,

You need security administrator. The same applies to imp which is a
pity because it would be useful for our developers otherwise.

Jeremy


--
jruffer


_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://ext-cando.kettleriverconsulti...fo/info-ingres