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 is currency type in database ?
What are the uses of Rollback Segment ?
Where do you use decode and case statements?
What is meant by joins?
How do we create privileges in oracle?
What is connection pooling in oracle?
What is a user account in oracle?
What is translate in oracle?
How a tablespace is related to data files?
I have created one package with out procedures in package specification and in package body i have used 2 procedures. is it compile????
How to upsert (update or insert into a table)?
What are the varoius components of physical database structure of oracle database?