Converting a User-Extended Role Back to a User

You can convert a user-extended role back to a regular user.

Prerequisites

Requires administrative rights over the user-extended role being converted.

Task

The user retains any login privileges, system privileges and roles granted to the user-extended role. The user remains as the owner of the objects that were created after the user was extended to act as a role. Any members of the user-extended role are immediately revoked.

A minimum number of role or global role administrators (as defined by the MIN_ROLE_ADMINS database option) with a login password must exist for each role at all times. When converting a user-extended role back to a user, all dependent roles of the user-extended role must continue to meet this minimum requirement, or the conversion fails.

To convert a user-extended role back to a user, execute one of these:

Convert Condition	Statement
Role has not been granted any members.	DROP ROLE FROM USER `role_name`
Role has been granted members.	DROP ROLE FROM USER `role_name` WITH REVOKE

Convert Condition

Statement

Role has not been

granted any members.

DROP ROLE FROM USER role_name

Role has been

granted members.

DROP ROLE FROM USER role_name

WITH REVOKE