Delete Provision Request

Applicable only when endDateOnDelete is set to false.

Set the value of the useRestrictOnDrop parameter to false to drop all the associated objects with this user. In this case the CASCADE option will be used when dropping the user along with the following actions:

• The schema with the user's name and the schemas belonging to the user, together with all the objects stored in them (even if they are created by other users) are deleted.

• Objects owned by the user, even if they are part of another schema, are deleted.

• Objects that are dependent on deleted objects are deleted.

• Public synonyms owned by the deleted user are deleted.

• Privileges on deleted objects are revoked. Privileges granted by the deleted user are revoked. Revoke privileges may cause further revokes if they have been granted further.

• Users created by the deleted user and roles created by the user are not deleted.

• Audit policies created by the deleted user are not deleted.

Set the value of the useRestrictOnDrop parameter to true for using the RESTRICT option when dropping the account. In this case, the account will not be deleted:

• If it is the owner of any object other than the schema with its name (and other schemas) created by it.

• If there is an object stored in one of its schemas which was not created by it.