[
https://issues.apache.org/jira/browse/TRAFODION-2389?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15727231#comment-15727231
]
ASF GitHub Bot commented on TRAFODION-2389:
-------------------------------------------
Github user robertamarton commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/870#discussion_r91204885
--- Diff: docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc ---
@@ -486,62 +534,52 @@ catalog name and resubmit.
== SQL 1036
```
-Only super ID can execute DROP SQL.
+Authorization ID <auth-id-1> cannot grant to authorization ID <auth-id-2>
because it could create a circular dependency.
```
-*Cause:* An attempt was made to drop SQL by a user who is not the super
-ID.
+Where <auth-id-1> is the authorization ID performing the GRANT.
+
+Where <auth-id-2> is the authorization ID that is the target of the GRANT.
+
+*Cause:* There is a chain of grants leading from <auth-id-2> back to
<auth-id-1>. Granting
+this request might create a circular dependency.
*Effect:* The operation fails.
-*Recovery:* The super ID needs to issue the DROP SCHEMA statement.
+*Recovery:* None.
<<<
[[SQL-1037]]
== SQL 1037
```
-{project-name} is not installed on system <node>.
+Revoke failed because of a dependent grant between authorization ID
<auth-id-1> and authorization ID <auth-id-2>.
```
-Where <node> is the name of the node referenced by the operation.
-
-*Cause:* In a replication or distribution context: An operation
-attempted to create a catalog reference or a partition on a node where
-the {project-name} database has not been installed.
-
-*Effect:* The operation fails.
-
-*Recovery:* Either reissue the statement specifying a different node, or
-install the {project-name} database on <node> and resubmit.
-
-[[SQL-1038]]
-== SQL 1038
-
-```
-Not all user catalogs have been dropped from the system.
-```
+Where <auth-id-1> and <auth-id-2> are authorization IDs.
-*Cause:* You attempted to drop SQL while one or more user-created
-catalogs existed.
+*Cause:* You attempted to revoke a privilege from <auth-id-1>, but
+that user or role has granted that privilege to a third authorization ID.
*Effect:* The operation fails.
-*Recovery:* You must drop all user-created catalogs before dropping SQL.
+*Recovery:* None.
--- End diff --
Recovery: Reconnect to the {project-name} database using an authorization ID
that can revoke privileges from <auth-id-2> that were granted by
<auth-id-1> and resubmit.
> Update Messages Guide for some messages from 1000 - 1099
> --------------------------------------------------------
>
> Key: TRAFODION-2389
> URL: https://issues.apache.org/jira/browse/TRAFODION-2389
> Project: Apache Trafodion
> Issue Type: Sub-task
> Components: documentation
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
