Question 1 of 30
A database administrator is reviewing user access to a sensitive financial report within the Oracle Database. User A reports that they are unable to generate the report, despite being a member of the \"Finance\" role. Upon investigation, the administrator discovers that the \"Finance\" role does not include the necessary privileges to access the report. What should the administrator do to resolve this issue?
Grant the necessary privileges to the "Finance" role to allow access to the report.
Create a new role specifically for report generation and assign it to User A.
Remove User A from the "Finance" role and assign them a higher-level role with broader access.
Instruct User A to request access to the report through the standard approval process.

Preparing for Oracle Database Administration I? Now land the interview.

73% of qualified candidates get rejected because of weak resumes. Build an ATS-optimized, recruiter-ready resume in under 5 minutes - free to start.

Build My Resume Free