Comparing DQL and SQL Modes › Selecting a Mode › Security Implications

Security Implications

The following lists the security implications for DQL Mode and SQL Mode.

DQL Mode:

• Allows column level security using profile-codes.
• Allows conditions and restrictions based on column values.
• Allows restriction of table usage.
• Allows individual READ/UPDATE access by table or database.
• Can run on CA Datacom/DB security or an external security package while maintaining the ability to restrict access to columns..

SQL Mode:

• Requires use of views or GRANT and REVOKE to restrict user access.
• Requires authorization ID for each user.
• Relies on CA Datacom/DB for security.