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
How to revoke create session privilege from a user in oracle?
How to delete a column in an existing table in oracle?
How to create a new oracle data file?
What is oracle instant client?
How to create a new view in oracle?
What is difference between sid and service name in oracle?
How to use "for" statements in oracle?
Which is faster join or subquery in oracle?
What is using clause and give example?
How to create an initialization parameter file?
How to pass parameters to procedures in oracle?
How to synchronize 2 schema's objects?
What is the use of aggregate functions in oracle?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Can group functions be used in the order by clause in oracle?