Question: By using the database sqlAuthClientDB created in the above question, do the following: i) Tries to connect to the database without a username and password,
By using the database sqlAuthClientDB created in the above question, do the following: i) Tries to connect to the database without a username and password, raising an exception. ii) Tries to connect to the database as a user with no access, raising an exception. iii) Connects to the database as a user with read-only access; the connection succeeds, but an attempt to create a table raises an exception. iv) Connects to the database as mary, who has full access; this user creates and populates a table. This user also grants select and insert privileges on this table to another user. v) Connects to the database as sqlsam, the user who has been granted select and insert privileges by mary. This user has full (that is, read-write) access on the connection level, but has limited powers for this table because SQL authorization is active. The user successfully performs select and insert operations on the table, but an attempt to delete a row from the table raises an exception. vi) Connects to the database again as mary, who then deletes the table. vii) Shuts down the database.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
