GRANT Object-Level Privilege Statement

Grants database object-level privileges on individual tables or views to a user or role.

Quick Links:

Go to Parameters

Go to Usage

Go to Standards

Go to Permissions

Syntax

GRANT object-level-privilege [, …]
   ONowner.]object-name
   TO userID [,...]WITH GRANT OPTION ]

object-level-privilege
   ALLPRIVILEGES ] 
   | ALTER 
   | DELETE 
   | INSERT
   | LOAD
   | REFERENCE [ ( column-name [, …] ) ] 
   | SELECT [ ( column-name [, …] ) ] 
   | TRUNCATE
   | UPDATE [ ( column-name, …) ] }

Parameters

(back to top)

Usage

(back to top)

You can list the table privileges, or specify ALL to grant all privileges at once.

Standards

(back to top)

  • SQL–Syntax is an entry-level feature.
  • SAP Sybase Database product–Syntax is supported in Adaptive Server.

Permissions

(back to top)

Requires one of:
  • MANAGE ANY OBJECT PRIVILEGE system privilege
  • You have been granted the specific object privilege with the WITH GRANT OPTION clause on the table.
  • You own of the table.
Related reference
REVOKE Object-Level Privilege Statement