Documentation Comments

Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.

RealityV15.1Online Documentation (MoTW) Revision 7

GRANT Statement (SQL) (m691508+grant.htm)

To	Reality
Version
Topic
Submitted by
Company
Location
Email address
Comment

GRANT Statement

Gives privileges for a particular SQL table to users.

Syntax

GRANT [ ALL || grant-privilege {, grant-privilege{...}} ] ON table-name TO [ PUBLIC || user-name {, user-name{...}} ]

Syntax Elements

grant-privilege =
DELETE || INSERT || SELECT || UPDATE

table-name =
{owner-name.}table-identifier

owner-name
The SQL user-id of the creator of the table.

table-identifier
The name of the required table.

user-name
The SQL user-id of the user to be granted access.

Restrictions

Only the SQL owner of the table can perform this statement.
The owner of the table must have SQL Catalog Maintenance privilege set in the Reality security profile

Comments

Privileges granted to PUBLIC are available to all users.

The INSERT, UPDATE and DELETE privileges on a particular table can be overridden for all users by clearing the table's "update permission" flag in SQLM.

Examples

GRANT SELECT ON EMP TO PUBLIC 
GRANT ALL ON EMP TO admin