Create synonym for table : Synonym « User Previliege « Oracle PL / SQL

1. Oracle PL / SQL
2. User Previliege
3. Synonym

Create synonym for table

  
SQL>
SQL> CREATE TABLE source_log
  2  (backup_date    DATE,
  3   backup_time    VARCHAR2(6),
  4   last_ddl_time  DATE,
  5   owner          VARCHAR2(30),
  6   name           VARCHAR2(30),
  7   type           VARCHAR2(12),
  8   line           NUMBER,
  9   text           VARCHAR2(2000))
 10  /

Table created.

SQL> CREATE INDEX source_log_idx1 ON source_log
  2    (last_ddl_time, owner, name)
  3  /

Index created.

SQL> CREATE or replace PUBLIC SYNONYM source_log FOR source_log
  2  /

Synonym created.

SQL> GRANT SELECT, INSERT ON source_log to PUBLIC
  2  /

Grant succeeded.

SQL>
SQL> drop table source_log;

Table dropped.

SQL>
SQL>

   
  

Related examples in the same category