GRANT ALL

Syntax

GRANT ALL ON <external-table> to <user>;

This syntax is used to grant the permissions on external tables for other users.

Here is an example SQL to grant privileges to individual users on external tables:

GRANT ALL ON EXT_T1 TO samb,bob;