Tiêu đề Untitled document - 2024-08-30T142143.116.pdf ✅

Output: Grant succeeded. This command grants the CREATE TABLE and CREATE VIEW privileges to the user Jay. 3. Grant Select, Insert, Update on EMP to Jay GRANT SELECT, INSERT, UPDATE ON EMP TO Jay; Output: Grant succeeded. This command grants the SELECT, INSERT, and UPDATE privileges on the EMP table to the user Jay. 4. Grant Select, Update on Deptno, Empno Columns in Dept to Jay GRANT SELECT, UPDATE (deptno, empno) ON Dept TO Jay; Output: Grant succeeded. This command grants the SELECT and UPDATE privileges specifically on the deptno and empno columns of the Dept table to the user Jay. 5. Alter User Jay Identified by admin ALTER USER Jay IDENTIFIED BY admin; ``] **Output:** User altered. This command changes the password of the user `Jay` to `admin`. Practicalkida.com

Grant succeeded. This command grants the CREATE TABLE and CREATE VIEW privileges to the role emp_pvr. 10. Grant Role emp_pvr to Jay and John GRANT emp_pvr TO Jay, John; Output: Grant succeeded. Exercise 1. Create the user Jay and implement the following commands on table EMP and Dept. Answer: 1. Create User Jay CREATE USER 'Jay'@'localhost' IDENTIFIED BY 'admin'; 2. Grant CREATE TABLE and CREATE VIEW Privileges to Jay GRANT CREATE TABLE, CREATE VIEW ON *.* TO 'Jay'@'localhost'; 3. Grant SELECT, INSERT, UPDATE Privileges on the EMP Table to Jay GRANT SELECT, INSERT, UPDATE ON your_database.EMP TO 'Jay'@'localhost'; 4. Grant SELECT and UPDATE Privileges on Specific Columns in the Dept Table to Jay GRANT SELECT, UPDATE (deptno, empno) ON your_database.Dept TO 'Jay'@'localhost'; 5. Alter the User Jay's Password Practicalkida.com