试题详情
- 单项选择题You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others. Which statement accomplishes this? （）
A、GRANT select, insert, update ON student_grades TO manager
B、GRANT select, insert, update ON student_grades TO ROLE manager
C、GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;
D、GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;
E、GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;
F、GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;
关注下方微信公众号，在线模考后查看
热门试题
- Which two statements
- Examine the descrip
- Examine the descrip
- ClicktheExhibitbutto
- Evaluate these two
- EXHIBIT,EmpTable Ex
- In which scenario wo
- What is true about u
- In which scenario wo
- What is true about j
- What does the TRUNCA
- You need to calculat
- Which syntax turns a
- You are the DBA for
- TheSTUDENT_GRADEStab
- The EMP table conta
- Which two statements
- A SELECT statement
- Examine the structu
- Evaluate the SQL st