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

CREATE VIEW `databases1` AS SELECT emp_name from employees;

6s

UPDATE `databases1` SET `emp_name`='test3' WHERE `emp_name`='test2' LIMIT 1;

6t

GRANT select, update ON "databases1" TO "user1"@"localhost";

6u

UPDATE `databases1` SET `emp_name`='test4' WHERE `emp_name`='test3' LIMIT 1;

6v

CREATE USER 'sec1'@’localhost’;

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

6w

 GRANT SELECT ON "university"."subjects" TO "sec1"@"localhost";

6x

 select * from subjects

6y

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

6z

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

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



6aa


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


6bb

select * from subjects