DROP USER

 

Function

DROP USER deletes a previously defined CONNX user from the data dictionary.

 

Syntax

drop_user.bmp
 

user_identifier

An existing user identifier

 

Description

DROP USER removes an existing user identifier and the associated password.

 

Limitations

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.

 

ANSI Specifics

The DROP USER statement is not part of the Standard.

 

CONNX Specifics

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.

image19.gif