DROP USER
Function
DROP USER deletes a previously defined CONNX user from the data dictionary.
Syntax
DROP USER user_identifier
where
user_identifier | An existing user identifier |
Description
DROP USER removes an existing user identifier and the associated password.
Limitations
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.
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.
Warning:
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.
ANSI Specifics
The DROP USER statement is not part of the Standard.
Examples
The following example deletes the user 'Peter'
DROP USER 'PETER';