You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@trafodion.apache.org by db...@apache.org on 2016/12/07 23:45:52 UTC

[1/3] incubator-trafodion git commit: [TRAFODION-2389] Update some messages in the range 1000-1059

Repository: incubator-trafodion
Updated Branches:
  refs/heads/master 547dda169 -> 81005a720


[TRAFODION-2389] Update some messages in the range 1000-1059


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/03b4dce0
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/03b4dce0
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/03b4dce0

Branch: refs/heads/master
Commit: 03b4dce0412ae1059dec2edd5d1792c092c5cac1
Parents: 67a8fb4
Author: Dave Birdsall <db...@apache.org>
Authored: Tue Dec 6 22:56:03 2016 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Tue Dec 6 22:56:03 2016 +0000

----------------------------------------------------------------------
 core/sql/bin/SqlciErrors.txt                    |  16 +-
 core/sql/sqlcomp/CmpDDLCatErrorCodes.h          |  12 +-
 .../src/asciidoc/_chapters/ddl_msgs.adoc        | 179 ++++++++++++-------
 3 files changed, 131 insertions(+), 76 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/03b4dce0/core/sql/bin/SqlciErrors.txt
----------------------------------------------------------------------
diff --git a/core/sql/bin/SqlciErrors.txt b/core/sql/bin/SqlciErrors.txt
index ae8a5f7..1e65033 100644
--- a/core/sql/bin/SqlciErrors.txt
+++ b/core/sql/bin/SqlciErrors.txt
@@ -18,8 +18,8 @@
 1016 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Redundant references to column $0~ColumnName were specified in the constraint or trigger definition.
 1017 ZZZZZ 99999 BEGINNER MAJOR DBADMIN You are not authorized to perform this operation.
 1018 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Grant of role or privilege $0~String0 from $1~String1 to $2~String2 not found, revoke request ignored.
-1019 ZZZZZ 99999 ADVANCED MAJOR DIALOUT No valid primary partition for $0~TableName could be found.
-1020 ZZZZZ 99999 BEGINNER MINOR DBADMIN Privilege settings on metadata cannot be changed.
+1019 ZZZZZ 99999 BEGINNER MINOR DBADMIN --- unused ---
+1020 ZZZZZ 99999 BEGINNER MINOR DBADMIN Privilege settings on metadata tables cannot be changed.
 1021 ZZZZZ 99999 BEGINNER MINOR DBADMIN SQL is already initialized on system $0~string0.
 1022 ZZZZZ 99999 BEGINNER MINOR DBADMIN Schema $0~SchemaName already exists.
 1023 ZZZZZ 99999 BEGINNER MINOR DBADMIN Not authorized to create schema $0~SchemaName.
@@ -33,12 +33,12 @@
 1031 ZZZZZ 99999 BEGINNER MINOR DBADMIN Object $0~TableName could not be dropped.
 1032 ZZZZZ 99999 BEGINNER MINOR DBADMIN The DISPLAY command completes and the query is not executed.
 1033 ZZZZZ 99999 BEGINNER MINOR DBADMIN The table name is not specified.
-1034 ZZZZZ 99999 BEGINNER MAJOR DIALOUT Unable to obtain privileges
+1034 ZZZZZ 99999 BEGINNER MAJOR DIALOUT Unable to obtain privileges.
 1035 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Catalog $0~CatalogName already exists.
 1036 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Authorization ID $0~String0 cannot grant to authorization ID $1~String1 because it could create a circular dependency.
 1037 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Revoke failed because of a dependent grant between authorization ID $0~string0 and authorization ID $1~string1
-1038 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Not all user catalogs have been dropped from the system.
-1039 ZZZZZ 99999 BEGINNER MAJOR DBADMIN No privileges were revoked.  You lack the grant option for the specified privilege(s).
+1038 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
+1039 ZZZZZ 99999 BEGINNER MAJOR DBADMIN No privileges were revoked. You lack the grant option for the specified privilege(s).
 1040 ZZZZZ 99999 BEGINNER MAJOR DBADMIN The use of ALTER on metadata tables is not permitted.
 1041 ZZZZZ 99999 BEGINNER MINOR DBADMIN The primary key has already been defined.
 1042 ZZZZZ 99999 BEGINNER MINOR DBADMIN All PRIMARY KEY or UNIQUE constraint columns must be NOT NULL.
@@ -53,10 +53,10 @@
 1051 ZZZZZ 99999 BEGINNER MINOR DBADMIN You do not have the required privilege(s) on $0~TableName.
 1052 ZZZZZ 99999 BEGINNER MINOR LOGONLY Constraint cannot be dropped because it does not belong to the specified table.
 1053 ZZZZZ 99999 BEGINNER MINOR DBADMIN Unique index $0~TableName could not be created because the specified column(s) contain duplicate data.
-1054 ZZZZZ 99999 BEGINNER MINOR LOGONLY Index $0~TableName already exists.
+1054 ZZZZZ 99999 BEGINNER MINOR LOGONLY --- unused ---
 1055 ZZZZZ 99999 BEGINNER MINOR LOGONLY Object $0~TableName already exists.
-1056 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Request: alter view $0~string0 compile failed. Prepare of the view's select statement encountered error  $1~Int1. 
-1057 ZZZZZ 99999 BEGINNER MAJOR DBADMIN SQL objects cannot be created on $0~String0: File system error $1~NSKCode.
+1056 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused --- 
+1057 ZZZZZ 99999 BEGINNER MAJOR DBADMIN --- unused ---
 1058 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Unable to create histogram table $0~TableName.
 1059 ZZZZZ 99999 BEGINNER MAJOR DBADMIN Request failed.  Dependent constraint $0~ConstraintName exists.
 1060 ZZZZZ 99999 BEGINNER MINOR DBADMIN Request failed. View $0~string0 is invalid. 

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/03b4dce0/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
----------------------------------------------------------------------
diff --git a/core/sql/sqlcomp/CmpDDLCatErrorCodes.h b/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
index d4bbf25..0094001 100644
--- a/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
+++ b/core/sql/sqlcomp/CmpDDLCatErrorCodes.h
@@ -51,7 +51,7 @@ enum CatErrorCode { CAT_FIRST_ERROR = 1000
                   , CAT_REDUNDANT_COLUMN_REF_PK                   = 1016
                   , CAT_NOT_AUTHORIZED                            = 1017
                   , CAT_GRANT_NOT_FOUND                           = 1018
-                  , CAT_PARTITION_NOT_FOUND                       = 1019
+                  // , CAT_PARTITION_NOT_FOUND                    = 1019 no longer used
                   , CAT_SMD_PRIVS_CANNOT_BE_CHANGED               = 1020
                   , CAT_INITIALIZE_SQL_ALREADY_DONE               = 1021
                   , CAT_SCHEMA_ALREADY_EXISTS                     = 1022
@@ -69,7 +69,7 @@ enum CatErrorCode { CAT_FIRST_ERROR = 1000
                   , CAT_CATALOG_ALREADY_EXISTS                    = 1035
                   , CAT_CIRCULAR_PRIVS                            = 1036
                   , CAT_DEPENDENT_PRIV_EXISTS                     = 1037
-                  , CAT_CATALOGS_ARE_STILL_ON_THE_SYSTEM          = 1038
+                  // , CAT_CATALOGS_ARE_STILL_ON_THE_SYSTEM       = 1038 no longer used
                   , CAT_PRIVILEGE_NOT_REVOKED                     = 1039
                   , CAT_SMD_CANNOT_BE_ALTERED                     = 1040
                   , CAT_PRIMARY_KEY_ALREADY_DEFINED               = 1041
@@ -84,11 +84,11 @@ enum CatErrorCode { CAT_FIRST_ERROR = 1000
                   , CAT_DROP_FAILS_FOREIGN_KEY_EXISTS             = 1050
                   , CAT_INSUFFICIENT_PRIV_ON_OBJECT               = 1051
                   , CAT_CONSTRAINT_DOES_NOT_BELONG_TO_TABLE       = 1052
-                  , CAT_UNIQUE_INDEX_LOAD_FAILED_WITH_DUPLICATE_ROWS
-                  , CAT_INDEX_ALREADY_EXISTS                      = 1054
+                  , CAT_UNIQUE_INDEX_LOAD_FAILED_WITH_DUPLICATE_ROWS = 1053
+                  // , CAT_INDEX_ALREADY_EXISTS                   = 1054 no longer used
                   , CAT_TABLE_ALREADY_EXISTS                      = 1055
-                  , CAT_UNABLE_TO_ALTER_VIEW                      = 1056
-                  , CAT_LOCATION_NO_GOOD                          = 1057
+                  // , CAT_UNABLE_TO_ALTER_VIEW                   = 1056 no longer used
+                  // , CAT_LOCATION_NO_GOOD                       = 1057 no longer used
                   , CAT_HISTOGRAM_TABLE_NOT_CREATED               = 1058
                   , CAT_DEPENDENT_CONSTRAINT_EXISTS               = 1059
                   , CAT_VIEW_INVALID                              = 1060

http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/03b4dce0/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc
----------------------------------------------------------------------
diff --git a/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc b/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc
index b5bec6c..9b0df98 100644
--- a/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc
+++ b/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc
@@ -62,7 +62,7 @@ specified a schema that does not exist.
 == SQL 1004
 
 ```
-Table, view, or stored procedure <object-name> does not exist or object type is invalid for the current operation.
+Object <object-name> does not exist or object type is invalid for the current operation.
 ```
 
 Where <object-name> is the name of a {project-name} database object.
@@ -190,7 +190,7 @@ grant options.
 == SQL 1013
 
 ```
-Not all privileges were granted.  You lack grant option for the <privilege> privilege.
+Not all privileges were granted. You lack grant option for the <privilege> privilege.
 ```
 
 Where <privilege> is a {project-name} privilege on some {project-name} object..
@@ -254,6 +254,24 @@ local super ID can perform a replication operation for a catalog and for
 multiple schemas in a single catalog. Additionally, the schema owner can
 perform a replication operation for a single schema.
 
+[[SQL-1018]]
+== SQL 1018
+
+```
+Grant of role or privilege <privilege> from <user-or-role-1> to <user-or-role-2> not found, revoke request ignored.
+```
+
+Where <privilege> is a {project-name} privilege and <user-or-role-1> and <user-or-role-2> are user IDs or roles.
+
+*Cause:* You attempted to revoke a privilege from <user-or-role-2> via <user-or-role-1>, but <user-or-role-1>
+did not grant that privilege to <user-or-role-2>.
+
+*Effect:* The operation fails.
+
+*Recovery:* If <privilege> or <user-or-role-2> are incorrect, correct
+them and resubmit. If <user-or-role-1> is incorrect, reconnect to
+the {project-name} database via the correct user ID or role.
+
 <<<
 [[SQL-1020]]
 == SQL 1020
@@ -380,21 +398,18 @@ DROP SCHEMA statement.
 == SQL 1027
 
 ```
-The definition schema <definition-schema-name> is dropped when its catalog is dropped.
+The view <view-name> was created before column privileges were supported. To grant column privileges, please recreate the view.
 ```
 
-Where <definition-schema-name> is the name of the definition schema
+Where <view-name> is the name of the view
 specified.
 
-*Cause:* You attempted to drop the schema containing the metadata tables
-for the catalog.
+*Cause:* You attempted to grant column privileges on a view that was created
+on an earlier release of the {project-name} software, before column privileges were supported.
 
-*Effect:* No SQL objects are dropped.
+*Effect:* No column privileges were granted.
 
-*Recovery:* Use DROP SCHEMA statements to drop all the user-created
-schemas in the catalog. Then use the DROP CATALOG statement to drop the
-catalog. The schema <definition-schema-name> is dropped when you drop
-its catalog.
+*Recovery:* Drop and recreate the view, then resubmit the grant request.
 
 <<<
 [[SQL-1028]]
@@ -436,18 +451,20 @@ accompanying error messages to determine the cause.
 == SQL 1030
 
 ```
-File label <file-name> could not be accessed. File system error <error>.
+The HBase name has a length of <actual-length> which is too long. Maximum length supported is <max-length>.
 ```
 
-Where <file-name> is the name of a {project-name} database file.
+Where <actual-length> is the length of the generated HBase name.
 
-Where <error> is a file system error number.
+Where <max-length> is the maximum allowed HBase name length.
 
-*Cause:* See the accompanying error message for the cause.
+*Cause:* You attempted to create a {project-name} object which {project-name} stores in an HBase file.
+The generated HBase name (consisting of catalog name, schema name and object name, separated by periods)
+is too long for HBase.
 
 *Effect:* The operation fails.
 
-*Recovery:* For information about file system errors, see <<file_system_errors,File-System Errors>>.
+*Recovery:* Use a shorter name and resubmit.
 
 [[SQL-1031]]
 == SQL 1031
@@ -464,6 +481,37 @@ Where <object-name> is the SQL object.
 
 *Recovery:* Apply the recovery of the accompanying error message.
 
+[[SQL-1032]]
+== SQL 1032
+
+```
+The DISPLAY command completes and the query is not executed.
+```
+
+*Cause:* You used the DISPLAY command to get insight into the
+plan generated for a particular query. When DISPLAY is used,
+the query is not executed.
+
+*Effect:* The query is not executed.
+
+*Recovery:* If you wish to execute the query, resubmit without
+the DISPLAY command.
+
+[[SQL-1034]]
+== SQL 1034
+
+```
+Unable to obtain privileges.
+```
+
+*Cause:* You attempted a DDL or GRANT/REVOKE operation but {project-name}
+could not retrieve privilege information needed to process the request.
+Additional error messages may give insight to the cause.
+
+*Effect:* The operation is not executed.
+
+*Recovery:* None. Contact the {project-name} Developer Distribution List.
+
 <<<
 [[SQL-1035]]
 == SQL 1035
@@ -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.
 
 <<<
 [[SQL-1039]]
 == SQL 1039
 
 ```
-The DROP SQL statement could not be executed.
+No privileges were revoked. You lack the grant option for the specified privilege(s).
 ```
 
-*Cause:* See the accompanying error message for the cause.
+*Cause:* You attempted to revoke privileges from an authorization ID
+that does not have the grant option for those privileges.
 
-*Effect:* {project-name} does not drop SQL.
+*Effect:* The operation fails.
 
-*Recovery:* Apply the recovery of the accompanying error message.
+*Recovery:* Reconnect to the {project-name} database using an authorization ID
+that has grant option for these privileges and resubmit.
 
 [[SQL-1040]]
 == SQL 1040
@@ -684,7 +722,7 @@ on the DROP statement for the object.
 == SQL 1048
 
 ```
-The statement currently supports only RESTRICT drop behavior.
+The statement currently supports only RESTRICT behavior.
 ```
 
 *Cause:* Drop behavior CASCADE was specified on a DROP statement that
@@ -743,6 +781,21 @@ insufficient privileges.
 *Recovery:* See the {docs-url}/sql_reference/index.html[_{project-name} SQL Reference Manual_] for the required
 security needed to create a view or trigger.
 
+[[SQL-1052]]
+== SQL 1052
+
+```
+Constraint cannot be dropped because it does not belong to the specified table.
+```
+
+*Cause:* You specified ALTER TABLE DROP CONSTRAINT to drop a constraint from a given table.
+The constraint you specified, however, does not belong to the table you specified.
+
+*Effect:* The operation fails.
+
+*Recovery:* To learn if the constraint name is incorrect, use SHOWDDL on the
+table you specified. Correct the name and resubmit.
+
 [[SQL-1053]]
 == SQL 1053
 
@@ -761,40 +814,42 @@ constraint specified in the CREATE INDEX statement.
 change the rows in the table to remove duplicates. Then reissue the
 statement.
 
-<<<
-[[SQL-1057]]
-== SQL 1057
+[[SQL-1055]]
+== SQL 1055
 
 ```
-{project-name} objects cannot be created on <volume-name>: File system error <error-number>.
+Object <privilege-object> already exists.
 ```
 
-Where <volume-name> is the name of a volume.
+Where <privilege-object> is an object you specified on a REGISTER statement.
 
-Where <error-number> is the file system error number.
+*Cause:* You attempted to register a new privilege object in the 
+{project-name} database but this object already exists.
 
-*Cause:* An attempt to create a file on volume <volume-name> resulted in
-file system error <error-number>.
+*Effect:* The operation takes no action.
 
-*Effect:* The operation fails.
-
-*Recovery:* For information about file system errors, see <<file_system_errors,File-System Errors>>.
+*Recovery:* If the object name is incorrect, correct and resubmit.
 
+<<<
 [[SQL-1058]]
 == SQL 1058
 
 ```
-Lock <lock-name> already exists.
+Unable to create histogram table <table-name>.
 ```
 
-Where <lock-name> is the name of the DDL lock.
+Where <table-name> is the name of the histogram table that could not be created.
 
-*Cause:* The statement required creation of a lock with a unique lock
-name, which was not generated.
+*Cause:* You attempted to execute a CREATE SCHEMA statement, but one
+of the histogram tables needed for the schema could not be created.
+This message may be accompanied by other messages that shed more light
+on the problem.
 
 *Effect:* The operation fails.
 
-*Recovery:* Specify a unique lock name and resubmit.
+*Recovery:* None. Contact the {project-name} Developer Distribution List.
+Supply the name of the table that could not be created and any accompanying
+error messages.
 
 <<<
 [[SQL-1059]]


[3/3] incubator-trafodion git commit: Merge [TRAFODION-2389] PR 870 Update Messages Guide msgs 1000-1059

Posted by db...@apache.org.
Merge [TRAFODION-2389] PR 870 Update Messages Guide msgs 1000-1059


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/81005a72
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/81005a72
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/81005a72

Branch: refs/heads/master
Commit: 81005a7204c3bc5b0df436b4117d0b5c64746b61
Parents: 547dda1 ee2c06b
Author: Dave Birdsall <db...@apache.org>
Authored: Wed Dec 7 23:44:38 2016 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Wed Dec 7 23:44:38 2016 +0000

----------------------------------------------------------------------
 core/sql/bin/SqlciErrors.txt                    |  16 +-
 core/sql/sqlcomp/CmpDDLCatErrorCodes.h          |  12 +-
 .../src/asciidoc/_chapters/ddl_msgs.adoc        | 181 ++++++++++++-------
 3 files changed, 133 insertions(+), 76 deletions(-)
----------------------------------------------------------------------



[2/3] incubator-trafodion git commit: Reworks addressing Roberta's comments

Posted by db...@apache.org.
Reworks addressing Roberta's comments


Project: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/commit/ee2c06bd
Tree: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/tree/ee2c06bd
Diff: http://git-wip-us.apache.org/repos/asf/incubator-trafodion/diff/ee2c06bd

Branch: refs/heads/master
Commit: ee2c06bd9618467251e05e5257f55ea77eb23ee7
Parents: 03b4dce
Author: Dave Birdsall <db...@apache.org>
Authored: Wed Dec 7 20:02:10 2016 +0000
Committer: Dave Birdsall <db...@apache.org>
Committed: Wed Dec 7 20:02:10 2016 +0000

----------------------------------------------------------------------
 .../src/asciidoc/_chapters/ddl_msgs.adoc        | 24 +++++++++++---------
 1 file changed, 13 insertions(+), 11 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/ee2c06bd/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc
----------------------------------------------------------------------
diff --git a/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc b/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc
index 9b0df98..2bd872c 100644
--- a/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc
+++ b/docs/messages_guide/src/asciidoc/_chapters/ddl_msgs.adoc
@@ -264,7 +264,8 @@ Grant of role or privilege <privilege> from <user-or-role-1> to <user-or-role-2>
 Where <privilege> is a {project-name} privilege and <user-or-role-1> and <user-or-role-2> are user IDs or roles.
 
 *Cause:* You attempted to revoke a privilege from <user-or-role-2> via <user-or-role-1>, but <user-or-role-1>
-did not grant that privilege to <user-or-role-2>.
+did not grant that privilege to <user-or-role-2>. Note that <user-or-role-2> can be PUBLIC but <user-or-role-1>
+cannot.
 
 *Effect:* The operation fails.
 
@@ -563,7 +564,9 @@ that user or role has granted that privilege to a third authorization ID.
 
 *Effect:* The operation fails.
 
-*Recovery:* None.
+*Recovery:* Reconnect to the {project-name} database using an authorization ID
+that can revoke the dependent privileges, then reconnect again under the
+original authorization ID and resubmit.
 
 <<<
 [[SQL-1039]]
@@ -573,8 +576,8 @@ that user or role has granted that privilege to a third authorization ID.
 No privileges were revoked. You lack the grant option for the specified privilege(s).
 ```
 
-*Cause:* You attempted to revoke privileges from an authorization ID
-that does not have the grant option for those privileges.
+*Cause:* You attempted to revoke privileges from an authorization ID, but you do not
+have the ability (grant option) to perform this operation.
 
 *Effect:* The operation fails.
 
@@ -818,17 +821,17 @@ statement.
 == SQL 1055
 
 ```
-Object <privilege-object> already exists.
+Object <component-name> already exists.
 ```
 
-Where <privilege-object> is an object you specified on a REGISTER statement.
+Where <component-name> is a component name you specified on a REGISTER COMPONENT statement.
 
-*Cause:* You attempted to register a new privilege object in the 
-{project-name} database but this object already exists.
+*Cause:* You attempted to register a new component in the 
+{project-name} database but this component already exists.
 
 *Effect:* The operation takes no action.
 
-*Recovery:* If the object name is incorrect, correct and resubmit.
+*Recovery:* If the component name is incorrect, correct and resubmit.
 
 <<<
 [[SQL-1058]]
@@ -842,8 +845,7 @@ Where <table-name> is the name of the histogram table that could not be created.
 
 *Cause:* You attempted to execute a CREATE SCHEMA statement, but one
 of the histogram tables needed for the schema could not be created.
-This message may be accompanied by other messages that shed more light
-on the problem.
+Additional error messages may give insight to the cause.
 
 *Effect:* The operation fails.