SET PASSWORDS statement
Wed, 03/04/2009 - 20:02 | 
hdanzl
Set one ore more passwords.
Syntax
|
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 |
Tags:
Questions? Problems?
- Interested to buy but something put you off?
- Can't find what you're looking for?
- Have a suggestion?
Let us know. If you're having trouble contacting us, please check here.
Site Updates
- Dec 4 2024 - 1:53pm
- Dec 4 2024 - 1:48pm
- Nov 19 2024 - 1:04pm
- Oct 17 2024 - 10:27am
- Jul 24 2024 - 1:22pm