Skip to main content

SHARE KEY (bSQL) | Blockpoint Docs

Shares an existing key with another database user. For examples, see Examples.

bSQL Syntax Conventions

Syntax​

SHARE KEY "key_name" WITH <database_principal> 

<database_principal> ::=   
    Database_user   
    | Database_role

[IMPORTANT] Database principals in the SHARE KEY command are currently restricted to logins in the master database.

Arguments​

key_name
The name of the key to be shared.

database_principal
The user or role to receive access to the key.

Permissions​

Any user can share a key, but the user must have ownership of the key. Once shared, the target database principal can use the key to encrypt and decrypt blockchain data and files.

Examples​

Creating and sharing a key.​

The following example creates a new symmetric key named "shipKey", and shares the key with the user product_manager.

CREATE KEY 
SYMMETRIC "shipKey"
SHARE KEY
"shipKey" WITH  product_manager

See Also​