Assigning permissions when using SQL queries
In general, hides the underlying database from the user. The 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 as one of these users without permission to access the database, you cannot issue the SQL query.
To access non- 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
acme.ARAdmin.CUSTMR_INFO
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*