6a

CREATE USER 'user1'@’localhost’ IDENTIFIED BY 'user1';
GRANT SELECT ON "university"."employees" TO "user1"@"localhost";

6b

--nic--

6c

DROP TABLE employees

6d

select * from subjects

6e

GRANT DELETE ON "university"."teams" TO "user1"@"localhost";

6f

--nic--

6g

delete from teams where team_id = '1';

6h

GRANT SELECT ON "university"."teams" TO "user1"@"localhost";

6i

delete from teams where team_id = '1';


6j

CREATE VIEW `databases` AS SELECT employee_id, emp_name from employees;

6k

GRANT SELECT ON "databases" TO "user1"@"localhost";

6l

SELECT `employee_id`, `emp_name` FROM `university`.`databases`

6m

select * from employees

----------------------------------------------------------------------------------
----------------------------------------------------------------------------------

6n

UPDATE `databases` SET `emp_name`=’test’
WHERE `employee_id`=1 AND `emp_name`='MUSHROOM' LIMIT 1;


6o

GRANT update ON "databases" TO "user1"@"localhost";

6p

UPDATE `databases` SET `emp_name`='test'
WHERE `employee_id`=1 AND `emp_name`='MUSHROOM' LIMIT 1;

6q

UPDATE `databases` SET `emp_name`='test2' WHERE `employee_id`=1 LIMIT 1;

6r



6s



6t



6u



6v



6w



6x



6y



6z



6aa



6bb