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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sequence?

633


How to set a transaction to be read only in oracle?

597


How to define an oracle cursor variable?

586


What is data file?

628


How to sort output in descending order in oracle?

588






How to use values from other tables in update statements using oracle?

578


Can you tell me how to add new column in existing views?how?How is possible?

948


What happens if the imported table already exists?

555


What is a dead lock in oracle?

608


How to delete all rows a table in oracle?

633


What are the various constraints used in oracle?

567


Differentiate between function and procedure in oracle.

573


Explain the importance of .pll extension in oracle?

566


What is the purpose of save points in oracle database?

557


How to get the Installed Oracle Version Information ?

633