Vertica创建User和Schema

在Vertica中创建User和Schema命令如下

=> CREATE USER <user> IDENTIFIED BY '<password>';
=> CREATE SCHEMA <schema>;
=> GRANT ALL ON schema <schema> TO <user>;

比如

=> CREATE USER ms IDENTIFIED BY 'password';
=> CREATE SCHEMA ms;
=> GRANT ALL ON schema ms TO ms;