Assigning permissions when using SQL queries

In general, AR System hides the underlying database from the user. The  AR System server interacts with the database and provides information to the user independent of the underlying database. All access through the API supplied with the product goes through this server and is independent of the database.

To use SQL queries, familiarize yourself with your underlying database. All SQL queries are issued by the following users:

Database

User

Microsoft SQL Server

ARAdmin

Oracle

ARAdmin

If you run AR System as one of these users without permission to access the database, you cannot issue the SQL query.

To access non-AR System databases, use the database name as part of the SQL query syntax. For example, for Microsoft SQL Server database:

databaseName.owner.table
acme.ARAdmin.CUSTMR_INFO

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*