Doris创建表、视图，用户和授权

1. 创建表

create table sales_records(record_id int, seller_id int, store_id int, sale_date date, sale_amt bigint) distributed by hash(record_id) properties("replication_num" = "1");

2. 创建视图

CREATE VIEW test.example_view
(
record_id ,
seller_id
)
AS
SELECT record_id , seller_id FROM sales_records;

3. 创建jack用户，并赋予sales_records表权限。

CREATE USER jack@'127.0.0.1' IDENTIFIED BY '123456';
GRANT SELECT_PRIV,ALTER_PRIV,LOAD_PRIV ON test.sales_records TO 'jack'@'%';

4. 创建alex用户，并赋予example_view表权限。

CREATE USER alex@'127.0.0.1' IDENTIFIED BY '123456';
GRANT SELECT_PRIV,ALTER_PRIV,LOAD_PRIV ON test.example_view TO 'alex'@'%';

5. 登录验证。

mysql -P9030 -h127.0.0.1 -u alex -p123456