DQ Internal Security › Securing Data Access for SQL Use › Limiting SQL Authorization

Limiting SQL Authorization

CA Dataquery provides your users with access to SQL with the option of using:

• SELECT only
• Data Definition Language with use of CREATE, COMMENT ON, DROP, GRANT, and REVOKE commands
• Data Maintenance Language with use of INSERT, UPDATE, and DELETE commands

We suggest that you limit authorization to Data Definition Language and Data Maintenance Language to a CA Dataquery Administrator. The CA Dataquery Administrator can create the necessary queries to perform these functions on the tables and/or data where appropriate, thus safeguarding the integrity of your system and its data.