创建用户
CREATE USER test IDENTIFIED BY &&passwd
DEFAULT TABLESPACE USERS;授权
GRANT CONNECT,RESOURCE TO test;
GRANT CREATE TABLE,CREATE VIEW,CREATE SYNONYM TO test;
从一个用户为另一个用户授权查看自己的表
GRANT SELECT ON tablename TO USERNAME;
创建同义词
CREATE SYNONYM tablename FOR username.tablename;