CREATE USER - Create authorization identifier

You use CREATE USER to create a new authorization identifier.

The current authorization identifier must have the special privilege CREATE USER.

---

CREATE USER authorization_identifier

       AT CATALOG catalog

---

authorization_identifier

Name of the authorization identifier. The first 10 characters of the authorization identifier must be unique within the database.

AT CATALOG catalog

Name of the database for which the authorization identifier is to be valid.

Example

Define the authorization identifiers UTIUSR1 and UTIUSR2 for the ORDERCUST database.

	CREATE USER utiusr1 AT CATALOG ordercust
	CREATE USER utiusr2 AT CATALOG ordercust

See also

DROP USER, CREATE SYSTEM_USER