Question

oracle 如何去掉owner user前缀.

oracle 如何去掉owner user前缀. 即把select deptnum,deptname from hr.department;
变成select deptnum,deptname from department。

Answer 1

楼上说的没错，做同义词就能解决owner user前缀。具体步骤如下：
1、先登入department表的owner user，授予必要的权限。
例：grant select on department to public;
2、登入sys或system用户，创建同义词。
例：create public synonym department for hr.department;
3、登入任意一个用户都可按select * from department语句查询。

Answer 2

做个同义词啊，create public synonym for hr.department;

Answer 3

用HR用户登录就不用前缀了