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



6o



6p



6q



6r



6s



6t



6u



6v



6w



6x



6y



6z



6aa



6bb