SQL> CREATE USER production IDENTIFIED BY production;

User created.

SQL> CREATE USER user1 IDENTIFIED BY user1;

User created.

SQL> GRANT dba TO production;

Grant succeeded.

SQL> GRANT connect TO user1;

Grant succeeded.

SQL> CONNECT production/production
Connected.
SQL> CREATE TABLE tab1 (col1 DATE);

Table created.

SQL> GRANT SELECT ON tab1 TO user1;

Grant succeeded.

SQL> CONNECT user1/user1
Connected.
SQL> CREATE SYNONYM tab1 FOR production.tab1;

Synonym created.

SQL> DESC tab1
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 COL1                                               DATE

SQL> CREATE VIEW view1 AS SELECT * FROM production.tab1;

View created.