ON KEY
Syntax
GRANT { ENCRYPT | DECRYPT | HMAC | ALL [ PRIVILEGES ] }
ON KEY key_name
TO { role_specification } [, ...] [ WITH GRANT OPTION ]
Parameters
- ON KEY
- Grant privileges on an encryption key created with the CREATE KEY command.
- ENCRYPT
- Privilege to encrypt data, using a specific key.
- DECRYPT
- Privilege to decrypt data, using a specific key.
- HMAC
- Privilege to run the
HMAC_KS
function with a specific key as input to the function.
Examples
Grant
ENCRYPT
privilege on key yb100key
to user
yb100
:premdb=# grant encrypt on key yb100key to yb100;
GRANT
Grant both
ENCRYPT
and DECRYPT
privileges on key
yb100key
to user
yb100
:premdb=# grant all privileges on key yb100key to yb100;
GRANT
Grant
HMAC
privilege on a
key:premdb=# grant hmac on key playerkey to bobr;
GRANT