문제 Given the following table definition and SQL
statements:
CREATE TABLE (COL1 int, col2 CHAR(40), col3 int)
GRANT insert, update, select, references on table table1 to
user usera
Which of the following SQL statements will revoke privieges
for user USERA on COL1 and COL2?
A. REVOKE UPDATE ON TABLE table1 FROM USER usera
B. REVOKE ALL PRIVILEGES ON TABLE table1 FROM USER usera
C. REVOKE ALL PRIVILEGES ON TABLE table1 COLUMNS (col1, col2)
FROM usera
D. REVOKE REFERENCES ON TABLE table1 COLUMNS (col1, col2) FROM
USER usera
|