How Do I Set an Independent Oracle Account That Has the Least Privilege and Uses DRS?
To perform a full migration for an Oracle database, you must grant the CREATE SESSION, SELECT ANY TRANSACTION, SELECT ANY TABLE, and the SELECT ANY DICTIONARY permissions to the user. If you need to perform an incremental migration, the user must have the log parsing permission. If the destination database is a PostgreSQL database, the SELECT ANY SEQUENCE permission is also required. This section describes how to set an independent Oracle account that has the least privilege and uses DRS.
- Full migration
- Create a user for migration. User1 is used as an example.
Example command: CREATE USER User1 IDENTIFIED BY pwd
User1 indicates the username and pwd indicates the password.
- Run the following statement as user sys or as user who has the DBA permission to grant the required permissions to User1:
Example command: GRANT CREATE SESSION, SELECT ANY TRANSACTION, SELECT ANY TABLE, SELECT ANY DICTIONARY TO User1
- Create a user for migration. User1 is used as an example.
- Full+incremental migration
- Create a user for migration. User1 is used as an example.
- Run the following statement as user sys or as user who has the DBA permission to grant the required permissions to User1:
Example command: GRANT CREATE SESSION, SELECT ANY TRANSACTION, SELECT ANY TABLE, SELECT ANY DICTIONARY TO User1
- Run the following statement as user sys or as user who has the DBA permission to grant the log parsing permission to User1:
- If Oracle version is earlier than 12c, run the following statement:
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot