×
英语
很抱歉。本文没有你的语言版本。

GRANT Statement

Grants specific privileges to an existing user or group.

Syntax

GRANT {privilege[, privilege, …]} ON
{TABLE table |
OBJECT object|

CONTAINER container } TO {authorizationname[, authorizationname, …]}

The GRANT statement has these parts:

Part

Description

privilege

The privilege or privileges to be granted. Privileges are specified using the following keywords:

SELECT, DELETE, INSERT, UPDATE, DROP, SELECTSECURITY, UPDATESECURITY, DBPASSWORD, UPDATEIDENTITY, CREATE, SELECTSCHEMA, SCHEMA and UPDATEOWNER.

tablename

Any valid table name.

object

This can encompass any non-table object. A stored query (view or procedure) is one example.

container

The name of a valid container.

authorizationname

A user or group name.



扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×