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
Get step-by-step solutions from verified subject matter experts
