授权用户Jean查询帐户表的权限,使用的SQL语句是()
A.GRANT SELECT FROM 帐户 TO Jean
B.GRANT SELECT FROM 帐户 ON Jean
C.GRANT SELECT ON Jean FROM 帐户
D.GRANT SELECT ON 帐户 TO Jean
- · 有3位网友选择 C,占比33.33%
- · 有3位网友选择 B,占比33.33%
- · 有3位网友选择 A,占比33.33%
A.GRANT SELECT FROM 帐户 TO Jean
B.GRANT SELECT FROM 帐户 ON Jean
C.GRANT SELECT ON Jean FROM 帐户
D.GRANT SELECT ON 帐户 TO Jean
A GRANT SELECT ON 帐户 TO Jean
B GRANT SELECT TO Jean ON 帐户
C GRANT SELECT TO帐户 ON Jean
D GRANT SELECT ON Jean TO 帐户
A.A.GRANT SELECT ON 帐户 TO Jean
B.B.REVOKE SELECT ON 帐户 FROM Jean
C.C.DENY SELECT ON 帐户 TO Jean
D.D.REVOKE SELECT ON 帐户 TO Jean
A.GRANTSELECTON帐户TOJean
B.GRANTUPDATEONJeanFROM帐户
C.GRANTINSERT帐户ONJean
D.GRANTCREATETABLETOJean
A.A.DENY SELECT FROM 帐户 ON Jean
B.B.DENY UPDATE ON 帐户 TO Jean
C.C.DENY INSERT INTO 帐户 ON Jean
D.D.DENY UPDATE FROM 帐户 ON Jean
SQL Server 2008中,如果希望用户u1在DBl数据库中具有查询T1表的权限,正确的授权语句是()。
A.GRANT SELECT ON DB1(T1)TO u1
B.GRANT SELECT TO u1 ON DB1(T1)
C.GRANT SELECT TO u1 ON T1
D.GRANT SELECT ON T1 TO u1
SQL Server 2000中,如果希望用户u1在DB1数据库中具有查询T1表的权限,正确的授权语句是______。
A)GRANT SELECT ON DB1(T1)TO u1
B)GRANT SELECT TO u1 ON DB1(T1)
C)GRANT SELECT TO u1 ON T1
D)GRANT SELECT ON T1 TO u1
A.GRANT SELECT ON 账户 TO July
B.GRANT SELECT TO July on 账户
C.GRANT SELECT TO 账户 ON Jean
D.GRANT SELECT ON July TO 账户
在SQL的授权语句中使用“ALL PRIVILEGES”,表示( )。
A.授权所有用户 B.所有的操作权限
C.对所有的数据集合 D.允许再授权
将查询SC表的权限授予用户U1,并允许该用户将此权限授予其他用户。实现该功能的 SQL语句是______。
A.GRANT SELECT TO SC U1 WITH PUBLIC
B.GRANT SELECT ON SC TO U1 WITH PUBLIC
C.GRANT SELECT TO SC ON U1 WITH GRANT OPTION
D.GRANT SELECT ON SC TO U1 WITH GRANT OPTION
A.GrantSelectToTeacherOnLiuWithPublic
B.GrantSelectOnTeacherToLiuWithPublic
C.GrantSelectToTeacherOnLiuWithGrantOption
D.GrantSelectOnTeacherToLiuWithGrantOption
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!