CA Datacom SQL Security › Implementing the SQL Security Model › Creating SQL Authorizations

Creating SQL Authorizations

There are two ways to create SQL authorizations:

SQL CREATE Statement

When a user issues a CREATE TABLE or CREATE VIEW SQL statement, CA Datacom/DB automatically creates authorizations. CA Datacom/DB gives the executor of the CREATE TABLE or CREATE VIEW statement all access rights for that table or view (READ, UPDATE, INSERT, DELETE, and ALTER) and marks these authorizations as "grantable," which means that the creator of the table or view may grant those access rights to other users.

SQL GRANT Statement

A user with a grantable access right may execute a GRANT statement to give that access right to some other user. If one user grants an access right to a second user using the WITH GRANT option, the second user may grant the access right to other users.