Create view myview as select * from UserA.table1

Create view myview as select * from UserA.Table1@Dblink

--creating userA
create user usera identified by aa;
grant create session to usera;
grant create table to usera;
grant create role to usera;
grant unlimited tablespace to usera;

--creating userb
create user userb identified by bb;
grant create session to userb;
grant create table to userb;
grant create database link to userb;
grant create view to userb;
grant unlimited tablespace to userb;

--connect as user A, make the table, role and grants
conn usera/aa
create table table1 as select * from dual;
create role myrole;
grant select on table1 to myrole;
grant myrole to userb;

--connect as userb, query the table directly, fail to create a view, 
--create a dblink, query via DB link then finally create the view using DBlink
conn userb/bb
select * from usera.table1;
create view myview as select * from usera.table1;
create database link dblink connect to USERB identified by bb using 'ocp11g';
select * from usera.table1@dblink;
create view myview as select * from usera.table1@dblink;
select * from myview;