Hide view definitions

[Sameer]

Create SYNONYM for the view and grant SELECT priviledge on the SYNONYM to user B

SQL> connect myuser/mypass
Connect durchgeführt.
SQL> 
SQL> create view sam as select * from helloworld where name like 'P%';

View created.

SQL> create synonym samv for sam;

Synonym created.

SQL> grant select on samv to scott;

Grant succeeded.
SQL> connect scott/tiger
Connect durchgeführt.
SQL> 
SQL> 
SQL> select * from myuser.samv where rownum = 1;
NAME
------------------------------
Production

SQL> select * from all_views where view_name = 'SAMV';

Es wurden keine Zeilen ausgewählt