Oracle Series: (23) synonyms

What is the synonym "synonym"?

(1) For some long names of objects (table, view, index, sequence, ...) ) do the subtraction, Replace with aliases

The role of synonyms

(1) Shorten the length of the object name

(2) Easy access to other users ' objects

Create synonyms that correspond to the Salgrade table,

Create synonym synonyms for table name/view/other objects

Create synonym E for salgrade;create synonym ev5 for emp_view_5;

650) this.width=650; "src=" http://s2.51cto.com/wyfs02/M02/87/19/wKioL1fULbXhPFLGAAA80fgF2SU136.jpg "title=" 018. JPG "alt=" wkiol1fulbxhpflgaaa80fgf2su136.jpg "/>

Grant Scott Normal user create synonym permissions as sys

Grant create synonym to Scott;

Revoke create synonym permissions from the Scott normal user as Sys

Revoke create synonym from Scott;

Using synonyms to manipulate salgrade tables

select * from S;

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M00/87/1B/wKiom1fULu2ydYwqAACPEHhOT8w609.jpg "title=" 019. JPG "alt=" wkiom1fulu2ydywqaacpehhot8w609.jpg "/>

Delete synonyms

drop synonym ev5;

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/87/1B/wKiom1fUL8DiOyiHAABeaRe5inY946.jpg "Title=" 020. JPG "alt=" wkiom1ful8dioyihaabeare5iny946.jpg "/>

Does deleting a synonym affect the base table?

Does not affect the base table

Does deleting a base table affect synonyms?

Will affect synonyms

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/87/19/wKioL1fUMLPRBxvvAADCMQ6lsgg534.jpg "title=" 021. JPG "alt=" wkiol1fumlprbxvvaadcmq6lsgg534.jpg "/>

Oracle Series: (23) synonyms