Makes sense, but I think DROP USER should also warn immediately if it
detects the most common case (I imagine) where the user owns things in
the current database.
andrew
Bruce Momjian wrote:
>If people want to remove a user, I assume they don't want to keep
>old objects around.
>
>How about if we created a script that goes through all the databases and
>reports items owned by a specific user, or orphaned items not owned by
>anyone?
>
>
>