You can convert a user-extended role back to a regular user.
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.
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 |