Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
How do I clear user's profile?
I found how I can drop the profile (also using CASCADE), but I want to keep the profile and just remove it from the user.
All users have a profile assigned. You can alter the user to have the default profile by:
ALTER USER username PROFILE DEFAULT;
Required, but never shown