REVOKE (Storage Location)

Revokes privileges from a user or role to read from or write to a storage location.

Note: The REVOKE (Storage Location) statement is applicable only to 'USER' storage locations. See GRANT (Storage Location) for more information. If the storage location is dropped, all user privileges are removed as part of that.

Syntax

REVOKE [ GRANT OPTION FOR ]
... { READ | WRITE | ALL [ PRIVILEGES ] }
... ON LOCATION [ 'path' [ ON node ]
... FROM { username | role | PUBLIC } [, ...]  
... [ CASCADE ]

Parameters

REVOKE OPTION FOR

Revokes GRANT privileges from the grantee.

 
READ

Revokes privileges from the grantee to copy data from files in a storage locations into a table.

 
WRITE

Revokes privileges to export Vertica data from the database to a storage location. Revoking WRITE privileges prevents the grantee from exporting COPY statement rejected data and exceptions files to a storage location.

 
ALL

Revokes all privileges from the grantee to the storage location. 

PRIVILEGES

For SQL standard compatibility and is ignored.

 
{ username | role | PUBLIC } [,...]

Revokes privileges from one or more users, one or more roles, or all users (PUBLIC).

  • username – A specific user
  • role – A particular role
  • PUBLIC – Revokes privileges from all users and roles. 
ON LOCATION ( 'path' [ ON node ] )
  • path— Specifies the path name mount point of the storage location
  • node— [Optional] Revokes access to the storage location residing on the node. If you leave this blank, node defaults to all nodes on the specified path in that cluster. If a path exists for only some nodes, the entire grant rolls back, even on the nodes that reside in the path.
 
CASCADE

Revokes privileges from the grantee. Using the CASCADE keyword when revoking privileges first removes them from the initial grantee. The statement then revokes all privileges from other users and roles to whom the grantee extended storage location access.

Examples

For examples, see GRANT (Storage Location)

See Also