单选题
1分
SQL Server 2008中,如果希望用户u1在DB1数据库中具有查询T1表的权限,正确的授权语句是()
参考答案: A
参考解析: SQL Server 2008中GRANT的用法为:
GRANT { ALL [ PRIVILEGES ] }
| permission [ ( column [ ,...n ] ) ] [ ,...n ]
[ ON [ class :: ] securable ] TO principal [ ,...n ]
[ WITH GRANT OPTION ] [ AS principal ]