GRANT (View)

Grants view privileges to users and roles.

Syntax

GRANT privilege
   ON [[database.]schema.]view[,…] 
   TO grantee[,…] 
   [ WITH GRANT OPTION ]

privilege	One of the following: SELECT: Query the specified views. `ALL [PRIVILEGES]`: Grants all view privileges that also belong to the grantor. Grantors cannot grant privileges that they themselves lack. The optional keyword `PRIVILEGES` conforms with the SQL standard.
`[database.]schema`	Specifies a schema, by default `public`. If schema is any schema other than `public`, you must supply the schema name. For example: myschema.thisDbObject If you specify a database, it must be the current database.
view	The target view.
view	The target view.
grantee	Specifies who is granted privileges, one of the following: User name Role `PUBLIC`: The default role of all users
`WITH GRANT OPTION`	Gives grantee the privilege to grant the same privileges to other users or roles. For details, see How to Grant Privileges in the Administrator's Guide.

One of the following:

Superuser
Privileges grantee who was given the option (WITH GRANT OPTION) of extending these privileges to other users

Grant user Joe all privileges on view ship.

=> CREATE VIEW ship AS SELECT * FROM public.shipping_dimension;
CREATE VIEW

=> GRANT ALL PRIVILEGES ON ship TO Joe;
GRANT PRIVILEGE