创建用户user1,并为它授予create table、create view 的系统权限以及connect 的系统角色。
回收user1 的create table、create view 的系统权限
答:
create user user1 identified by user1;
grant create table,create view to user1;
grant connect to user1;
以user1用户的身份登录系统:
![](https://img2020.cnblogs.com/blog/1440360/202006/1440360-20200624165426730-1189355339.png)
说明授权成功;
revoke create table ,create view from user1;
![](https://img2020.cnblogs.com/blog/1440360/202006/1440360-20200624165521644-4296771.png)
5