Unable to delete user from Aster database

Aster R
Not applicable

Unable to delete user from Aster database

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.

Tags (1)
2 REPLIES

Re: Unable to delete user from Aster database

Hello, have you deal with this problem?

I have the same problem with dropping user.

Teradata Employee

Re: Unable to delete user from Aster database

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.

 

http://knowledge.teradata.com/KCS/id/KCS008813

 
Let me know if you have further questions.