As a database administrator, you've been asked to configure access for a new team member. They are required to view and generate reports from a database but should not be allowed to modify any data. Which type of permission should you grant to the new team member?
The correct answer is 'Read-only access' because it allows the new team member to view and create reports from the database without the ability to alter any data. 'Full access' would allow them to modify data, which is not desired in this scenario. 'No access' would prevent them from viewing any data, and 'Write-only access' does not typically exist as a permission level since it would allow data modification without the ability to read it, which is not a practical use case.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is read-only access in databases?
Open an interactive chat with Bash
What are different types of database permissions?
Open an interactive chat with Bash
Why is it important to restrict data modification in databases?