SQL>connking/oracle
Connected.
SQL>
SQL>select * from scott.emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- ---------
---------- ------------ ---------- ----------
DEPTNO
----------
7839KINGPRESIDENT 17-NOV-81 5500
10
SQL>
SQL>connward/oracle
Connected.
SQL>select * from scott.emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- ---------
---------- ------------ ---------- ----------
DEPTNO
----------
7521WARDSALESMAN 7698 22-FEB-81 1250 500
30
SQL>
在scott用户下也是一样的,因为emp表中ename包含scott
SQL>connscott/tiger
Connected.
SQL>select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM
---------- ---------- ---------
---------- ------------ ---------- ----------
DEPTNO
----------
7788SCOTTANALYST 7566 19-APR-87 3000
20
SQL>
只要包含sal列,那么就会只显示当前用户信息。
查询时不包含sal列会显示有用信息。
SQL>select ename from scott.emp;
ENAME
----------
SMITH
ALLEN
WARD
JONES
MARTIN
BLAKE
CLARK
SCOTT
KING
TURNER
ADAMS
ENAME
----------
JAMES
FORD
MILLER
14 rows selected.
SQL>