[
https://issues.apache.org/jira/browse/TRAFODION-2156?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15684821#comment-15684821
]
ASF GitHub Bot commented on TRAFODION-2156:
-------------------------------------------
Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/845#discussion_r88993842
--- Diff: docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---
@@ -4816,59 +4821,67 @@ grantor is:
* `_privilege_ [,_privilege_ ] … | all [privileges]`
+
-specifies the privileges to grant. you can specify these privileges for an
object.
+Specifies the privileges to grant. You can specify these privileges for an
object.
+
[cols="25%,75%"]
|===
-| select | can use the select statement.
-| delete | can use the delete statement.
-| insert | can use the insert statement.
-| references | can create constraints that reference the object.
-| update | can use the update statement on table objects.
-| execute | can execute a stored procedure using a call statement or
can execute a user-defined function (UDF).
-| usage | can access a library using the create procedure or create
function statement. this privilege provides you
-with read access to the library’s underlying library file.
-| all | all the applicable privileges. when you specify all for a
table or view, this includes the select, delete,
-insert, references, and update privileges. when the object is a stored
procedure or user-defined function (UDF), only the
-execute privilege is applied. when the object is a library, only the
update and usage privileges are applied.
+| DELETE | Can use the delete statement.
+| EXECUTE | Can execute a stored procedure using a call
statement or can execute a user-defined function (UDF).
+| INSERT [column-list] | Can use the insert statement.
+| REFERENCES [column-list] | Can create constraints that reference the
object.
+| SELECT [column-list] | Can use the select statement.
+| UPDATE [column-list] | Can use the update statement on table objects.
+| USAGE | For libraries, can access a library using the
create procedure or create
+function statement. This privilege provides you with read access to the
library’s underlying library
--- End diff --
Did you mean, "... read access to the function's underlying library"?
> Update SQL reference manual for column level privileges
> -------------------------------------------------------
>
> Key: TRAFODION-2156
> URL: https://issues.apache.org/jira/browse/TRAFODION-2156
> Project: Apache Trafodion
> Issue Type: Improvement
> Components: documentation
> Reporter: Roberta Marton
> Assignee: Roberta Marton
>
> Column level privileges support should be documented in the reference manual.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
