试述GRANT语句中WITH GRANT OPTION子句的作用。
第1题:
如果在GRANT语句中指定了【 】子句,则获得该语句中指定权限的用户还可以把这种(些)权限再转授给其它用户。
第2题:
把查询SC表的权限授予用户U1,并允许该用户再将此权限授予其他用户。实现此功能的正确SQL语句是______。
A.GRANT SELECT TO TABLE SC ON U1 WITH PUBLIC
B.GRANT SELECT ON TABLE SC TO U1 WITH PUBLIC
C.GRANT SELECT TO TABLE SC ON U1 WITH GRANT OPTION
D.GRANT SELECT ON TABLE SC TO U1 WITH GRANT OPTION
第3题:
在SQL中,若允许用户将已获得的某种权限再转授予其他用户,可以在GRANT语句中指定【 】子句。
第4题:
第5题:
试述在REVOKE语句中GRANT OPTION FOR子句和CASCADE子句的作用。
第6题:
您需要授予用户BOB对“雇员”表的SELECT权限。您希望允许BOB将此权限授予其他用户。应使用以下哪条语句()
第7题:
试述GRANT语句中WITH GRANT OPTION子句的作用。
第8题:
The HR user creates a view with this command: SQL> CREATE VIEW emp_v AS SELECT * FROM scott.emp; Now HR wants to grant the SELECT privilege on the EMP_V view to the JIM user. Which statement is true in this scenario?()
第9题:
The user Sue issues this SQL statement: GRANT SELECT ON sue. EMP TO alice WITH GRANT OPTION; The user Alice issues this SQL statement: GRANT SELECT ON sue. EMP TO reena WITH GRANT OPTION; The user Reena issues this SQL statement: GRANT SELECT ON sue. EMP TO timber; The user Sue issues this SQL statement: REVOKE select on sue. EMP FROM alice; For which users does the revoke command revoke SELECT privileges on the SUE.EMP table?()
第10题:
WITH GRANT
WITH GRANT FOR
WITH GRANT OPTION
WITH GRANT PERMISSION
第11题:
第12题:
It allows a grantee DBA privileges.
It is required syntax for object privileges.
It allows privileges on specified columns of tables.
It is used to grant an object privilege on a foreign key column.
It allows the grantee to grant object privileges to other users and roles.
第13题:
利用SQL的GRANT语句可向用户授予操作权限。当用该语句向用户授予操作权限时,若允许用户将获得的权限再授予其他用户,应在该语句中使用短语( )。 A.WITH PRIVILEGES B.WITH OPTION C.WITH GRANT OPTION D.WITH ALL PRIVILEGES
第14题:
(53)
A.RESTRICT
B.CASCADE
C.WITH GRANT OPTION
D.WITH CHECK OPTION
第15题:
● 将表Emp的empname属性列的修改权限授予用户LIU, 并允许LIU 再将此权限转授其他人,实现的SQL语句是 (48) 。
(48)
A. GRANT update on Emp TO LIU WITH CHECK OPTION
B. GRANT update(empname) on Emp TO LIU WITH CHECK OPTION
C. GRANT update on Emp TO LIU WITH GRANT OPTION
D. GRANT update(empname) on Emp TO LIU WITH GRANT OPTION
第16题:
第17题:
在SQL Server中,要授予某安全性帐户具有转授许可给其他安全性帐户的权限,则在授权时应加上()子句。
第18题:
The user SCOTT who is the owner of ORDERS and ORDERJTEMS tables issues the following GRANT command: GRANT ALL ON orders, order_items TO PUBLIC; What correction needs to be done to the above statement? ()
第19题:
在SQL SELECT语句中,GRANT命令属于数据控制功能。
第20题:
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? ()
第21题:
What is true about the WITH GRANT OPTION clause?()
第22题:
PUBLIC should be replaced with specific usernames.
ALL should be replaced with a list of specific privileges.
WITH GRANT OPTION should be added to the statement.
Separate GRANT statements are required for ORDERS and ORDERJTEMS tables.
第23题:
第24题:
GRANT select, insert, update ON student_grades TO manager
GRANT select, insert, update ON student_grades TO ROLE manager
GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;
GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;
GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;
GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;