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 the access through the APIs supplied with the product passes through this server and is independent of the database.
To use SQL queries, familiarize yourself with the underlying database of your AR System. All SQL queries are run by the following users:
If you run AR System as one of these users without permission to access the database, you cannot run the SQL query.
Database | User |
|---|---|
Microsoft SQL Server | ARAdmin |
Oracle | ARAdmin |
To access non-AR System databases, use the database name as part of the SQL query syntax. For example, for Microsoft SQL Server database:
acme.ARAdmin.CUSTMR_INFO