NexusDB Guide > SQL Reference > SQL Statements > Session Statements

NexusDB V3 Manual

SET PASSWORDS statement

NexusDB Manual V3 > SQL Reference > SQL Statements > Session Statements

Set one ore more passwords.

Syntax

<set passwords statement> ::=

SET PASSWORDS [ [ ADD | REMOVE ] password-list ]

Usage

The SET PASSWORDS statement is used to manage a list of encryption passwords for the current session. Tables that are encrypted with a password cannot be accessed in SQL statements unless the encryption password defined for the table is present in the list of passwords assigned to the session.

Notes

§	The password-list is a comma separated list of passwords.

§	SET PASSWORDS ADD password-list adds new passwords to the list.

§	SET PASSWORDS REMOVE password-list removes the passwords specified by password-list from the list.

§	SET PASSWORDS password-list sets the password list according to the argument, replacing any existing passwords.

§	SET PASSWORDS sets the password list to an empty string.

Examples

1)	The following example adds passwords to the password list of the current session:

SET PASSWORDS ADD 'pw100, pw101, pw102'

2)	The following example removes one of the existing passwords in the list:

SET PASSWORDS REMOVE 'pw101'

3)	The following example replaces the existing password list:

SET PASSWORDS 'pw103'

4)	The following example removes all passwords:

SET PASSWORDS

Conformance

NexusDB extensions

SET PASSWORDS statement

nexus_logo