DROP USER deletes a previously defined CONNX user from the data dictionary.
|
user_identifier |
An existing user identifier |
DROP USER removes an existing user identifier and the associated password.
Before issuing this statement, the DBA will have to make sure that the user to be removed does not own any objects in the catalog. Otherwise, an error message will be issued. The statement may only be executed by the DBA.
Caution: This statement is not subject to transaction logic. An implicit COMMIT will be performed after successful execution of this statement. If an error is detected during execution of this statement, an implicit ROLLBACK will be performed. Therefore, before executing this statement, it is strongly recommended to complete any open transaction containing INSERT, UPDATE and/or DELETE statements by issuing an explicit COMMIT or ROLLBACK statement.
The DROP USER statement is not part of the Standard.
None
Example
The following example deletes the user 'Peter'.
DROP USER 'PETER'
In order to drop users, you must be a database administrator. Database administrators are identified in the CONNX CDD as members of the group CONNXCDDAdministrators.
