why we can use synonym?
Answers were Sorted based on User's Feedback
Answer / srinivasa reddy k
We use synonym generally to hide the base schema name in
which the object lies, as well as it is easy to use.
Is This Answer Correct ? | 22 Yes | 2 No |
Answer / archana patil
Synonyms are an alternative name to table, to which we can
give perticular grants, so that main definition get hides
and as per grant it can be accessed.
Is This Answer Correct ? | 12 Yes | 2 No |
Answer / mohan kumar
SYNONYM-USING SYNONYM WE CAN EASILY ACCESS TO A TABLE OWNED
BY ANOTHER USER.IT SHORTENS THE LENGTHY OBJECT NAMES
Is This Answer Correct ? | 9 Yes | 5 No |
Answer / ramesh babu v
For security purpose of the table.other person can't
modifying the database table
Is This Answer Correct ? | 4 Yes | 2 No |
to save memory also we can use synonyms, y bcz its not
accupy any memory ok
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rama rao
It shorten the lenthy schema.It hide the information for
unauthorized persons and it reduce the time,memory consume.
In your aplication what we need to hide the information
that time is requried.
Is This Answer Correct ? | 0 Yes | 0 No |
How will U link GL with OU in Multi-org environment.
define steps of assigning items to an organization.
In oracle application how do you debug or trace errors?
How does accounting occured in Expense Reporting?
is it possible to run the interface without using oracle apps?
what are the different types of triggers in reports
What is an Index , Types od index why we are use index.
Stored procedure?
what is user exit and wat program do we write in user exit?
where we will put the control file ,where we will run sql star loader what is the cmd?
in procedure how to return a value
What is template?