数据库权限的赋予与回收

先登录有dba权限的用户

sqlplus sys/dwh as sysdba;

创建用户设置密码

create user aaa

idetified by pwd;

然后赋予权限链接权限

grant connect to aaa;

赋予查询的权利

grant select on emp to aaa;

回收权限

revoke select on emp from aaa;