Previous Topic: Plan SecurityNext Topic: Description of Non-Plan Security Diagram

SQL Statements › GRANT › Description of Plan Security Diagram

Description of Plan Security Diagram

EXECUTE

Grants the PLAN EXECUTE privilege.

BIND

Grants the PLAN BIND privilege.

ON PLAN plan-name

Specifies the name of the plan to which the PLAN EXECUTE or PLAN BIND privilege is to be granted.

TO accessor-id

Specify the accessor ID of one or more users to whom you are granting the privileges. This is a user's ID, not a schema auth-id. Do not specify your own accessor ID, that is to say, you cannot grant privileges to yourself.

TO PUBLIC

Specify PUBLIC when you are granting the specified privileges to all users. A new user automatically has any privileges previously granted to the public.

TO UNKNOWNUSER

Specify UNKNOWNUSER when you are granting the specified privileges to users whose identities cannot be determined by CA Datacom/DB security.

WITH GRANT OPTION

Specify this option if you want the user to whom you have granted the privilege to be able to grant it to another user. WITH GRANT OPTION cannot be used with PUBLIC.

WITH GRANT

Specify WITH GRANT if you want the user to whom you have granted the privilege to be able to grant it to another user. WITH GRANT cannot be used with PUBLIC or with UNKNOWNUSER.

Following is the non-plan security syntax diagram for the GRANT statement:

►►─ GRANT ─┬─ ALL ──────────────────────────────┬─ ON ─┬─────────┬────────────►
           ├─ ALL PRIVILEGES ───────────────────┤      └─ TABLE ─┘
           │ ┌─ , ────────────────────────────┐ │
           └─▼─┬─ SELECT ───────────────────┬─┴─┘
               ├─ INSERT ───────────────────┤
               ├─ DELETE ───────────────────┤
               ├─ UPDATE ─┬───────────────┬─┤
               │          └─ column-list ─┘ │
               ├─ ALTER ────────────────────┤
               └─ INDEX ────────────────────┘

   ┌─ , ──────────────┐        ┌─ , ───────────┐  
 ►─▼─┬─ table-name ─┬─┴─ TO ─┬─▼─ accessor-id ─┴─┬────────────────────────────►
     └─ view-name ──┘        ├─ PUBLIC ──────────┤
                             └─ UNKNOWNUSER ─────┘

 ►─┬─────────────────────┬────────────────────────────────────────────────────►◄
   ├─ WITH GRANT OPTION ─┤
   └─ WITH GRANT ────────┘

The following are CA Datacom/DB extensions.