How to create and manage view?
1、create user:
create user userName identified by password
2、set authority
grant authorityName to userName
3、set authority for creating view
grant create view to userName
4、lock or unlock user
alter user userName account[lock/unlock]
5、delete user
drop user userName
About view:
视图可以被看作一个虚拟表,它将一个查询结果当作一个表来使用,所有对视图的操作都会反映在基表上,因此对视图的操作必须符合基表数据的完整性约束。
1、create user:
create user userName identified by password
2、set authority
grant authorityName to userName
3、set authority for creating view
grant create view to userName
4、lock or unlock user
alter user userName account[lock/unlock]
5、delete user
drop user userName
About view:
视图可以被看作一个虚拟表,它将一个查询结果当作一个表来使用,所有对视图的操作都会反映在基表上,因此对视图的操作必须符合基表数据的完整性约束。