Upgrade to Admin

In Vertica is there a command similar to the "sudo" command in linux.


So I login as my regular account which has restricted permissions.


but suppose I need to do something which requires higher permissions, at that point of time It upgrades me to admin (just like sudo) temporarily.


this will prevent me from loggin in using super admin accounts which are always admin.


I remember sometime back somone showed me how to temprarily become an admin but executing this command. but I don't remember what it was


Very similar to sudo concept of unix.


  • Options


      I think you are referring of UDP's, where they are crreated with dbadmin role and can be granted to normal user for execution. 

     This is a risk ! 


     I don`t think you can impersonate dbadmin from inside a session unless you use username and password. 


  • Options

    I figured out the answer 


    set role pseudosuperuser;


Leave a Comment

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