DQ Internal Security › Securing Data Access for SQL Use

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