GRANT

Specifying grants DELETE, and SELECT privileges.

Specifying ROLE PUBLIC grants privileges to the PUBLIC role and hence to all users.

For GRANT statement to succeed, the user executing it should possess the specified privileges as well as the GRANT OPTION for those privileges.

Grant and SELECT privileges on the table orders to user alice:

Grant SELECT privilege on the table orders to everyone:

Some connectors have no support for GRANT. See connector documentation for more details.