<< Prev Question Next Question >>
Question 21/30
Examine these statements, which execute successfully:
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY 'P@ssw0rd';
GRANT r_world_rd TO john;
Examine these statements issued by user John:
What is the reason for the error?
CREATE ROLE r_world_rd;
GRANT SELECT ON world.* TO r_world_rd;
CREATE USER john IDENTIFIED BY 'P@ssw0rd';
GRANT r_world_rd TO john;
Examine these statements issued by user John:
What is the reason for the error?
