Options

db in single-user mode

Pietro_La_TorrePietro_La_Torre ✭
in General Discussion
Hi, is it possible to temporarily allow only one user to query the database ? thanks, Pietro.

Comments

  • Options
    Navin_CNavin_C Vertica Customer ✭
    Hi Pietro, It will require manual intervention. Ask the DBA to temporarily revoke all access from all users and grant a SELECT / USAGE access to only one user required by you. when he temporary time is fulfilled then you can grant all the revoked access to all users again. You can make a script for this, once script is made, you can assign it to a CRON expression for the temporary time period' Hope this helps.

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 ...