Session Logs
Hi there,
we are currently evaluating RDM in our team and we just activated the logging of sessions with "Prompt for comment on close". We are now facing the problem that it seems only to work if the user is an RDM Admin. For a non RDM admin user neither the session nor the comment is logged.
What are we missing here? Any missing permissions?
We use Active Directory auth with SQL server backend.
Many thanks
Markus
All Comments (4)
Hi,
This is not the expected behavior. Could you verify the logs in Help->View Application Logs. Could it be possible that your users does have an UPDATE/INSERT access to some table in the database like ConnectionLog?
David Hervieux
Hi,
well there is nothing in the "View Application Logs" beyond a bunch of "INFO Upgrading database for data source 'Local Data Source'" messages.
However since it was not clear what permissions are needed for each user on the SQL DB we just assigned "pbulic" and "datareader", since we where not able to find documentation.
What kind of permissions shoud a standard user have to the RDM SQL DB?
Many thanks
Markus
Hello,
RDM does assign the proper permissions itself when it creates the user.
Do you see the same effect when using a user created by the application?
Maurice
Hi Maurice,
good point. I removed the login of the user and recreated it via the RMD application and also let it create the corresponding SQL login. It seems to work now.
Thanks for the advice. However there should be better documentation on that that topics. That would have avoided my questions. I will do more tests with my team tomorrow.
Many thanks
Markus