- 创建表
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");
- 创建视图
CREATE VIEW test.example_view
(
record_id ,
seller_id
)
AS
SELECT record_id , seller_id FROM sales_records;
- 创建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'@'%';
- 创建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'@'%';
- 登录验证。
mysql -P9030 -h127.0.0.1 -u alex -p123456