Database security issues
To use SQL queries, familiarize yourself with your underlying database.
All SQL queries are issued by the following users:
Users of SQL queries
If you run BMC Remedy AR System as one of these users without permission to access the database, you cannot issue the SQL query.
To access non-BMC Remedy AR System server 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*