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

How to change the authentication's host?

I try to change host of authentication becase server's host is changed..

I used below query but error message is occured

How can i change the authentication's host?

Answers

  • Jim_KnicelyJim_Knicely Administrator

    Remove the SET keyword from your command.

    Example:

    verticademos=> CREATE AUTHENTICATION jim METHOD 'hash' HOST '10.10.10.0';
    CREATE AUTHENTICATION
    
    verticademos=> ALTER AUTHENTICATION jim HOST '10.10.10.0/32';
    ALTER AUTHENTICATION
    

    See: ALTER AUTHENTICATION

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
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.