[
https://issues.apache.org/jira/browse/TRAFODION-3103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16509088#comment-16509088
]
ASF GitHub Bot commented on TRAFODION-3103:
-------------------------------------------
Github user liuyu000 commented on a diff in the pull request:
https://github.com/apache/trafodion/pull/1601#discussion_r194599785
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -5958,6 +6098,122 @@ GRANT SELECT (part_no, part_name), DELETE ON TABLE
invent.partloc
GRANT SELECT ON TABLE invent.partloc TO ajones;
```
+* This example explains how to grant the `SELECT` privilege to PUBLIC.
+
++
+The _testuser1_ creates the table _t1_. The _testuser2_ and _testuser3_ do
not have the `SELECT` privilege on the table _t1_.
+
++
+_testuser2_:
+
++
+```
+SQL>SELECT * FROM t1;
+
+*** ERROR[4481] The testuser2 does not have SELECT privilege on table or
view TRAFODION.SEABASE.T1. [2018-06-11 11:39:16]
+```
+
++
+The _testuser1_ grants the `SELECT` privilege on table _t1_ to PUBLIC,
which means granting `SELECT` privilege to all users (_testuser2_ and
_testuser3_).
+
--- End diff --
Thanks @robertamarton, your comment has been incorporated :pencil2:
> Add Descriptions and Examples for *GRANT Statement* in *Trafodion SQL
> Reference Manual*
> ---------------------------------------------------------------------------------------
>
> Key: TRAFODION-3103
> URL: https://issues.apache.org/jira/browse/TRAFODION-3103
> Project: Apache Trafodion
> Issue Type: Documentation
> Reporter: Liu Yu
> Assignee: Liu Yu
> Priority: Major
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
