Programming

SQL> show user
USER is "USER12"
SQL> select * from scott.emp;
select * from scott.emp
                    *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> conn scott/tiger
Connected.
SQL> grant select on emp to user12;

Grant succeeded.

SQL> conn user12/user12
Connected.
SQL> select count(1) from scott.emp;

  COUNT(1)
----------
        14

SQL> show user
USER is "USER12"

SQL> select grantor, grantee, table_name from user_tab_privs;

GRANTOR                        GRANTEE                        TABLE_NAME
------------------------------ ------------------------------ ------------------------------
SCOTT                          USER12                         EMP


SQL> select view_name from all_views where view_name like '%PRIV%' order by 1;
...
...

select fld1 from username.table;