when a grant option is encountered for a table EMP to a
peer sitting beside you who has already having the table of
that name (EMP), then what is the result?
Answers were Sorted based on User's Feedback
Answer / devraj
He will have the rights on both tables. But on query the
first result will be fetched from his schema table.
| Is This Answer Correct ? | 2 Yes | 1 No |
What are group functions in oracle?
What is mean by Program Global Area (PGA) ?
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
How to select an oracle system id (sid)?
What is SYSTEM tablespace and When is it Created?
How to apply filtering criteria at group level in oracle?
what is the syntax of ALTER command?
How to add another datafile to a tablespace?
When does a Transaction end ?
Are truncate and delete commands same? If so why?
Is there a function to split a string in plsql?
How can we force the database to use the user specified rollback segment?