Question: In this exercise, you will create two users and a role. You will grant privileges directly to the first user, but you will grant privileges

In this exercise, you will create two users and a role. You will grant privileges directly to the first user, but you will grant privileges to the second user by granting privileges to the role and then assigning the user to that role. In addition, you will use MySQL Workbench to connect as the two users, check the privileges for the first user, and check the active roles for the second user

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!

I need som help with this sql project. In this exercise, you will create two users and a role. You will grant privileges directly to the first user, but you will grant privileges to the second user...

-- DESCRIPTION -- This script creates the SQL*Plus demonstration tables in the -- current schema. It should be STARTed by each user wishing to -- access the tables. SET TERMOUT ON PROMPT Building...

Use SQL Developer to execute SQL statements to complete the following tasks: 1. Create an index on the employee Last Name column of the employee table. 2. Create an index on the combination of Last...

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

Project 20-1: Manage a list of countries JAVA (NetBeans) with MySQL Database Console ========================================== Welcome to the Country Manager 1 - List countries 2 - Add a country 3 -...

Project 20-1: Manage a list of countries Console Welcome to the Country Manager 1 - List countries 2 - Add a country 3 - Exit Enter menu number: 1 India Japan Mexico Spain United States 1 - List...

JAVA (NetBeans) with MySQL Database Project 20-1: Manage a list of countries ****************************************************************************************************** DO NOT COPY AND...

Project 20-2: Manage customer data JAVA (NetBeans) with MySQL Database Console ================================================ Welcome to the Customer Manager COMMAND MENU list - List all customers...

Shady Tree produces two products: M1 and M2. There are no beginning inventories or ending work-in- process inventories of either M1 or M2. A single plantwide overhead rate is used to allocate...

Why must hospital personnel wear special conducting shoes while working around oxygen in an operating room. What might happen if the personnel wore shoes with rubber soles?

You are a wise professional who starts saving from the first year of employment. You save the following amounts at the end of each year: Year 1 2 3 4 5 6 Savings $ 5 0 0 0 0 6 0 0 0 0 7 0 0 0 0 8 0 0...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Question Does the put option impose special obligations on the employer, and if so, how can that obligation be financed?

Question Can a self-employed person adopt a profit sharing plan?

Question What special issues are involved in money purchase plans covering shareholder-employees in an S corporation?