Insert query rules

[Former Member]

I have an insert query in a remote DB.

If I execute it with developer or administrator user, it works.

If I execute it with an normal user (starting a transaction), it doesn't work.

The error is:

You do not have permission to access server ...

Where I have to set the execution rules for the group "XMII user"?

I tried to insert "XMII user" in transaction and in query settings, but it is not right.

Thank you a lot

Fabio

[jcgood25 · Accepted solution]

If the "..." in your access server error message is the name of the data server connection, then your user may not belong to a Role that has the permission to use the connection.

Check the Security Services...Data Access from the Menu.jsp (and pick your DB connection).

By default when a new data server is created it only has a few predefined roles configured to use it.