[ https://issues.apache.org/jira/browse/TRAFODION-3103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16508228#comment-16508228 ]
ASF GitHub Bot commented on TRAFODION-3103: ------------------------------------------- Github user robertamarton commented on a diff in the pull request: https://github.com/apache/trafodion/pull/1601#discussion_r194449791 --- 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 -- Word smith suggestion: The _testuser1_ grants the ... privilege to all current and future users (_testuser2_ and _testuser3_). > 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)