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