CA Datacom SQL Security › Implementing the SQL Security Model › Deleting Access Rights

Deleting Access Rights

SQL Authorizations are deleted:

• When a user executes a REVOKE statement to cancel an authorization previously granted with a GRANT statement.
• When a table or view is dropped.
• When the accessor who bound a plan loses the access rights to one of the resources used in the plan.