Syntax

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