CREATE TABLE students (
student_id INT PRIMARY KEY,
name VARCHAR(50),
birth_date DATE,
major VARCHAR(50)
);
INSERT INTO students (student_id, name, birth_date, major) VALUES (2021001, '김철수', '2000-01-01', '컴퓨터공학');
SELECT * FROM students WHERE student_id = 2021001;
GRANT SELECT ON students TO user1;
REVOKE SELECT ON students FROM user1;
COMMIT;
ROLLBACK;