Question: i) Creates a database named sqlAuthClientDB. The connection URL creates the database as the user mary, who is therefore the database owner. After SQL authorization

i) Creates a database named sqlAuthClientDB. The connection URL creates the database as the user mary, who is therefore the database owner. After SQL authorization is enabled, only the database owner will have the right to set and read database properties. ii) Sets database properties that create users with different levels of access (no access, read-only access, and full access), that require authentication, and that turn on SQL authorization. The users mary and sqlsam have full access. iii) Closes the connection, then shuts down the database so that the authentication and SQL authorization changes can take effect.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!