Syntax

Click to skip syntax diagram
Read syntax diagramSkip visual syntax diagram                 .-PRIVILEGES-.
>>-GRANT--+-ALL--+------------+---------------------------+----->
          | .-,-----------------------------------------. |
          | V                                           | |
          '---+-ALTER---------------------------------+-+-'
              +-DELETE--------------------------------+
              +-INDEX---------------------------------+
              +-INSERT--------------------------------+
              +-REFERENCES--+-----------------------+-+
              |             |    .-,-----------.    | |
              |             |    V             |    | |
              |             '-(----column-name-+--)-' |
              +-SELECT--------------------------------+
              '-UPDATE--+-----------------------+-----'
                        |    .-,-----------.    |
                        |    V             |    |
                        '-(----column-name-+--)-'
 
                  .-,--------------.
       .-TABLE-.  V                |
>--ON--+-------+----+-table-name-+-+---------------------------->
                    '-view-name--'
 
       .-,----------------------.
       V                        |
>--TO----+-authorization-name-+-+--+-------------------+-------><
         '-PUBLIC-------------'    '-WITH GRANT OPTION-'