Securing Data Access for SQL Use

Security is an important consideration in the use of SQL.

When you authorize users to use SQL, only CA Datacom/DB data security is in effect which means that CA Dataquery assumes that the user can access the entire database. Consult with the CA Datacom/DB Security Administrator for a complete understanding of CA Datacom/DB security.

CA Dataquery Security provides the following security measures for SQL Mode:

Password access on a system, query group, or individual level
SQL Mode authorization to use
- SQL
- Specific SQL commands
  INSERT, UPDATE, and DELETE
  CREATE, COMMENT ON, DROP, GRANT, and REVOKE
- Personal tables
Query access