🎴 Flashcard Mode

SQL and Oracle Database Fundamentals

Card1 / 20
Mastered0
Review0
QuestionClick to flip

Which two roles or privileges must you have to export tables owned by another user? (Choose two)

AnswerClick to flip back
A
CREATE SESSION
B
EXP_FULL_DATABASE
💡 Explanation:

To export tables owned by another user, you must have the CREATE SESSION privilege to connect to the database and the EXP_FULL_DATABASE role to export objects belonging to other schemas.

Change Mode