单项选择题

Which of the following statements allows USER1 to take away read access on the table ORG.TAB1 from USER2?（）

A.REVOKE SELECT FROM user2 ON TABLE org.tab1
B.REVOKE SELECT ON TABLE org.tab1 FROM user2
C.REVOKE READ ACCESS FROM user2 ON TABLE org.tab1
D.REVOKE READ ACCESS ON TABLE org.tab1 FROM user2

点击查看答案

上一题目录下一题

相关考题

单项选择题

On which of the following database objects may the SELECT privilege be controlled?（）

A.Sequence
B.Schema
C.Group
D.View

单项选择题

A "trusted" client needs to communicate with a server that has been configured to use CLIENT authentication. Which of the following will be used to verify passwords?（）

A.User ID/password file
B.Communications layer
C.Client applications
D.Operating system

单项选择题

Which of the following statements is used to grant user TOM and Application team APPGRP the ability to add data to table TAB1?（）

A.GRANT ADD DATA ON TABLE tab1 TO GROUP tom appgrp
B.GRANT INSERT TO USER tom, GROUP appgrp ON TABLE tab1
C.GRANT INSERT ON TABLE tab1 TO USER tom, GROUP appgrp
D.GRANT ADD DATA ON TABLE tab1 TO USER appgrp, GROUP tom