Question 1 of 30
In a recent project, a database administrator is tasked with setting up user access for a new application on the Oracle Exadata Database Machine X9M. The administrator needs to ensure that users have the appropriate permissions while adhering to security best practices. Which approach should the administrator take to effectively manage user roles and permissions?
Create specific roles for each user based on their job functions and assign the minimum necessary privileges to those roles.
Assign all users the same role to simplify management and ensure they have access to all necessary resources.
Grant users direct access to the database objects they need without using roles to streamline the process.
Regularly review and update user roles to ensure they align with the latest organizational policies and practices.