CA Datacom SQL Security › SQL Security Model › Naming Accessor IDs in GRANT and REVOKE

Naming Accessor IDs in GRANT and REVOKE

Accessors are individuals or groups of individuals who attempt to access data protected by security. When naming an accessor in the SQL GRANT and REVOKE statements, only specify the name of the user. CA Datacom/DB assumes the node to be LOCAL (that is, you are not using distributed processing through CA Datacom STAR) and the type to be USER (that is, an individual identified by a specific user ID) except for the following case.

PUBLIC is a special, reserved accessor name. When used in an SQL GRANT or REVOKE statement, PUBLIC means all individuals and groups of individuals with either a known or an unknown ID.