Unable to delete user from Aster database:
We were trying to delete user from Aster database. However the error message is "user cannot be dropped as some objects are dependent on it".
I tried removing the role assigned to the user and revoke privilages. (I am unable to find which object is tagged to the user)
However i am unable to drop the user. Can community people help to provide me list of steps to drop an user.
There is a knowledge article "How to determine what objects are owned by a user across all databases in Aster cluster" - KCS008813 . It will contain a script and steps to run it. Once you have identified and resolved the dependencies, you should be able to drop the user.
Let me know if you have further questions.