We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


How do I block a db user — Vertica Forum

How do I block a db user

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

Comments

  • Sajan_SangraulaSajan_Sangraula
    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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...