GRANT (data loader)

Grants data-loader privileges to users and roles.

Grants privileges on automatic data loaders to users and roles. By default, only superusers and the owner can execute or alter a data loader.

Syntax

GRANT { privilege[,...] | ALL [ PRIVILEGES ] }
   ON DATA LOADER [schema.]name
   TO grantee[,...]
   [ WITH GRANT OPTION ]

Arguments

privilege
One of the following privileges:
ALL [PRIVILEGES]
Grants all privileges. Inherited privileges must be granted explicitly.
schema
Schema containing the data loader. The default schema is public.
name
Name of the data loader.
grantee

Who is granted privileges, one of the following:

WITH GRANT OPTION

Allows the grantee to grant and revoke the same privileges to other users or roles. For details, see Granting privileges.

Privileges

Non-superusers, one of the following:

  • Owner.

  • Privileges grantee given the option (WITH GRANT OPTION) of granting privileges to other users or roles.

See also