柠檬试题库
search
首页 计算机 公务员 驾照 关于

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 ]
复制题目向AI提问