SQL Server 2008中,如果希望用户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
热度🔥317
参考答案:A
解析:
SQL Server 2008中GRANT的用法为:
GRANT { ALL [ PRIVILEGES ] }
| permission [ ( column [ ,...n ] ) ] [ ,...n ]
[ ON [ class :: ] securable ] TO principal [ ,...n ]
[ WITH GRANT OPTION ] [ AS principal ]