User Profile Creation Problem (Transferred to Wiki)

When the DAPLS System Administrator creates a user’s profile in the DAPLS application, the following is executed behind the scenes:

1. Create User ID in Oracle

2. Create User ID in DAPLS

3. Grant ‘CREATE SESSION’ to the User ID

4. Grant a Role (this is level 10, 20, 30,…) to the User ID

However, there are times where the DAPLS System Administrator may have an issue in creating a user’s profile. In order to resolve this issue, it is necessary for Civil Aviation IT to delete the user’s profile, so that the DAPLS System Administrator will then be able to recreate the user’s profile successfully. To delete the user’s profile, it is necessary to run the following script on the Oracle backend using TOAD.

DROP USER <USER ID>CASCADE;