--同义词(别名)
注意：如果查看其他用户的表，报错表或视图不存在 可能是权限不足
需要授权：conn/as sysdba
grant select on hr.employees to scott;
conn scott/tiger
select count(*) from hr.employees;
conn/as sysdba
grant create synonym to scott;
conn scott/tiger
create synonym hremp for hr.employees; --创建私有同义词
select count(*) from hremp;
conn/as sysdba
grant create public synonym to scott;
conn scott/tiger
create public synonym hremp2 for hr.employees; --创建共有同义词
drop synonym hremp;
conn /as dba
grant drop public synonym hremp2 to scott;
conn scott/tiger
drop public synonym hremp2 --共有同义词操作(创建、删除)一般建议管理员删除操作...
