REVOKE (Library)
Revokes library privileges from users and roles.
Syntax
REVOKE [ GRANT OPTION FOR ] { USAGE | ALL [ PRIVILEGES ] } ON LIBRARY [[database.]schema.]library[,…] FROM grantee[,…] [ CASCADE ]
Parameters
GRANT OPTION FOR |
Revokes the grant option for the specified privileges. Current privileges for grantees remain unaffected. If you omit this clause, Vertica revokes both the grant option and current privileges. |
USAGE |
Revokes access to the specified libraries. Privileges on functions in these libraries must be separately revoked. |
ALL [PRIVILEGES] |
Revokes all library privileges that also belong to the revoker. Users cannot revoke privileges that they themselves lack. The optional keyword PRIVILEGES conforms with the SQL standard. |
[database.]schema |
Specifies a schema, by default myschema.thisDbObject If you specify a database, it must be the current database. |
library |
The target library. |
grantee | Specifies whose privileges are revoked, one of the following: |
CASCADE |
|
Examples
These commands show how to create a new library, and then grant and revoke user Fred
's USAGE privilege on that library.
=> CREATE LIBRARY MyFunctions AS 'home/dbadmin/my_functions.so'; => GRANT USAGE ON LIBRARY MyFunctions TO Fred; => REVOKE USAGE ON LIBRARY MyFunctions FROM Fred;