Explain the use of grant option in exp command.
- 1 Answers
- 1141 Views
- I also Faced
- E-Mail Answers
Answer / Rakesh
The GRANT OPTION in Oracle grants the ability to other users to further grant the same privilege that was granted. This means that, when you grant a privilege with the GRANT OPTION, the user who receives the privilege can subsequently grant it to others as well. It is particularly useful for delegating database management tasks to other users without granting them the highest system privileges.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the factors that affect OPTIMIZER in choosing an Optimization approach ?
What are the components of Logical database structure of ORACLE database?
How to grant create session privilege to a user in oracle?
Briefly explain what is literal? Give an example where it can be used?
How to export several tables together?
Difference between NO DATA FOUND and %NOTFOUND?
How will you differentiate between varchar & varchar2?
Explain how are indexes update?
What is a Segment ?
definition of cluster and non-clustered index?
What is the effect of setting the value 'FIRST_ROWS' for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
What is the fastest query method to fetch data from the table?
Oracle General 
