怎么在A用户下给B创建一个同义词 怎么在A用户下给B创建一个同义词,也就是说 在A用户下现在又一张temp表 然后我想在A模式中给B模式下建一个同义词让B能查看temp表 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 --先给A用户授予create public synonym权限,--在给A用户下的表temp创建公共同义词--最后你就可以在B用户下查看此同义词所表示的表了--下面是演示实例:Connected as scottcreate public synonym syn_emp for empORA-01031: insufficient privileges--权限不够Connected as SYSgrant create public synonym to scott;commit;--Connected as scottcreate public synonym syn_emp for emp;commit;--Connected as yeexunSQL> select * from syn_emp;EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO----- ---------- --------- ----- ----------- --------- --------- ------ 7369 SMITH CLERK 7902 1980-12-17 800.00 20 7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30 7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30 7566 JONES MANAGER 7839 1981-4-2 2975.00 20 7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30 7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30 7782 CLARK MANAGER 7839 1981-6-9 2450.00 10 7788 SCOTT ANALYST 7566 1987-4-19 3100.00 20 7839 KING PRESIDENT 1981-11-17 5000.00 10 7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30 7876 ADAMS CLERK 7788 1987-5-23 1100.00 20 7900 JAMES CLERK 7698 1981-12-3 950.00 30 7902 FORD ANALYST 7566 1981-12-3 3000.00 20 7934 MILLER CLERK 7782 1982-1-23 1300.00 1014 rows selected Oracle同义词创建及其作用 一个MyEclipse问题 刚写oracle存储过程 希望高人指点(未解决) 关于奖金分配问题,求助 数据库表设计 请教oracle job方面的问题,各位帮忙 进来指点下。 第二次安装数据库ins-20802错误 为什么在oracle查询,结果排序不一样? 基础问题 oracle无法登陆了? oracle中一个亿量级别的单表查询 oracle 数据恢复 进程存储与存储过程的区别?
--先给A用户授予create public synonym权限,
--在给A用户下的表temp创建公共同义词
--最后你就可以在B用户下查看此同义词所表示的表了
--下面是演示实例:
Connected as scott
create public synonym syn_emp for emp
ORA-01031: insufficient privileges
--权限不够
Connected as SYS
grant create public synonym to scott;
commit;
--
Connected as scott
create public synonym syn_emp for emp;
commit;
--
Connected as yeexun
SQL> select * from syn_emp;EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
7566 JONES MANAGER 7839 1981-4-2 2975.00 20
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10
7788 SCOTT ANALYST 7566 1987-4-19 3100.00 20
7839 KING PRESIDENT 1981-11-17 5000.00 10
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
7900 JAMES CLERK 7698 1981-12-3 950.00 30
7902 FORD ANALYST 7566 1981-12-3 3000.00 20
7934 MILLER CLERK 7782 1982-1-23 1300.00 1014 rows selected
Oracle同义词创建及其作用