For an SQL database perform the following 1. Create two database users: The firs

Question

For an SQL database perform the following

1. Create two database users: The first is a concatenation of first name "joe" and last name "smith". The second is a concatenation of first name "sally" and last name "may".

2. Assign the two users privileges to connect to the database.

3. Assign the user "joesmith" the privilege to select data from the employees table.

4. Assign the user "sallymay" all privileges to the Departments table.

5. Assign the user "joesmith" the privilege to execute any procedure.

6 Take away "sallymay" privilege to execute any SQL commands on the Departments table.

Explanation / Answer

1.

2.

3.

4.

5.

6.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.