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