Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How do I block a db user

I want to block specifically a user who is creating lot fo connections to DB. What's the command to block a user speicifically?


  • you can block the user by: alter user account lock; You can also limit the memory for the user or associate the user with a resource pool that restricts connections from the user to a pre-specified limit. /Sajan

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.