创建用户 ,
CREATE USER username IDENTIFIED BY password
GRANT -----------
创建角色
CREATE ROLE rolename
GRANT 权限 to rolename
GRANT select
on employees
to usename
向uesname授权employees表的查询权
收回用户权限
REVOKE {SELECT ,INSERT]
on employees
FROM usename
[CASCADE CONSTRAINTS]
CREATE PUBLIC DATABASE LINK hq.acme.com
USING 'sales';
创建数据库远程连接。