Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table. Hide data complexity. Simplify commands for the user. Present the data in a different perpecetive from that of the base table. Store complex queries.
A sequence generates a serial list of unique numbers for numerical columns of a databases tables.
A synonym is an alias for a table, view, sequence or program unit.
There are two types of Synonyms Private and Public.
A Private Synonyms can be accessed only by the owner.