CA Datacom Security Overview › SQL Security › Table Security

Table Security

An alternate way to protect table access is to use SQL GRANT and REVOKE statements. In this case, CA Datacom/DB security is still used to protect DBUTLTY functions and to control who can create tables and authorization IDs. You can use the ANSI-compliant SQL GRANT and REVOKE statements only to control access to tables and views.

You can choose to protect table access by CA Datacom/DB security or by SQL security at the database level by specifying YES or NO for the SQL-SECURITY attribute when defining databases to CA Datacom Datadictionary.

SQL table security cannot be administered externally.