單項選擇題

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

你可能感興趣的試題

單項選擇題

A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

A.REFERENCES
B.SELECT
C.UPDATE
D.ALTER

單項選擇題

Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?（）

A.REVOKE DROP ON t1 FROM PUBLIC
B.REVOKE UPDATE ON t1 FROM PUBLIC
C.REVOKE DELETE ON t1 FROM PUBLIC
D.REVOKE CONTROL ON t1 FROM PUBLIC

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

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

你可能感興趣的試題

A user needs to create a trigger that will update table T2 whenever a row is added to table T1. Assuming the user has all appropriate privileges for table T2, which privilege is required on table T1 to create the trigger?（）

Assuming PUBLIC has been granted all privileges on table T1, which of the following statements would continue to permit any user to add rows to table T1, but not remove them?（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线