SQL> grant select on dept to kriz;

Grant succeeded.

SQL> connect kriz/kriz@ora10
Connected.
SQL> select * from dept;
select * from dept
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> select * from scott.dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        50 MANAGING       ZAGREB
        67 a              b
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

6 rows selected.

SQL>