권한부여 (GRANT, REMOKE)

다음 문제를 풀어보세요.

17.69. 사용자 U1이 생성한 EMPLOYEE(Eno, Name, Salary) 테이블에 대해 다음의 SQL 명령을 순서대로 실행할 때, 권한 부여 에러가 발생하는 위치를 모두 모아놓은 것은?

1	U1: GRANT INSERT, DELETE ON EMPLOYEE TO U2;
2	U1: GRANT SELECT ON EMPLOYEE TO U3 WITH GRANT OPTION;
3	U2: GRANT INSERT ON EMPLOYEE TO U4;
4	U3: GRANT SELECT ON EMPLOYEE TO U5;
5	U5: GRANT SELECT ON EMPLOYEE TO U6;
6	U1: GRANT SELECT ON EMPLOYEE TO U6;
7	U1: REVOKE SELECT ON EMPLOYEE FROM U3;
8	U6: SELECT * FROM EMPLOYEE;
9	U5: SELECT * FROM EMPLOYEE;
10	U6: UPDATE EMPLOYEE SET Salary = Salary * 1.1;

1. 2, 3, 5

2. 3, 5, 10

3. 3, 5, 9, 10

4. 3, 5, 8, 9, 10

[풀이]

1. U1 → U2 (INSERT/DELETE)

2. U1 → U3 (SELECT) GRANT OPTION

3. U2 → U4 (INSERT) : [ERROR] 권한없음

4. U3 → U5 (SELECT)

5. U5 → U6 (SELECT) : [ERROR] 권한없음

6. U1 → U6 (SELECT)

7. U1 → U3 (SELECT) REVOKE

8. U6 

9. U5

10. U6 (UPDATE)  : [ERROR] 권한없음