db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "ReferenceManualTenTwo" by YipNg
Date Thu, 17 Aug 2006 18:32:27 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by YipNg:
http://wiki.apache.org/db-derby/ReferenceManualTenTwo

------------------------------------------------------------------------------
  ||DECLARE GLOBAL TEMPORARY TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefdeclaretemptable.html
HTML URL] || Yip || Under Restrictions on Declared Global Temporary Tables, GRANT and REVOKE
should be added to that restriction list. ||
  ||CREATE SCHEMA statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj31580.html
HTML URL] || Yip || CREATE SCHEMA syntax needs to be updated.  The following are also allowed:
 CREATE SCHEMA schema-name AUTHORIZATION user-name and CREATE SCHEMA AUTHORIZATION user-name.
 Addtional examples to use these new syntax would be nice. ||
  ||RENAME TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqljrenametablestatement.html
HTML URL] || Yip || RENAME TABLE needs to address that one can only perform renaming of a
table if the user is the database owner or the user have the authorization to the schema of
the table to be renamed. ||
+ ||LOCK TABLE statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj40506.html HTML
URL] || Yip || LOCK TABLE needs to address that one can only perform locking of a table if
the user is the database owner or the user have the proper privilege to execute such an action.
 This is not covered in the design spec. ||
  
  [[Anchor(sqlreservedwords)]]'''SQL Reserved Words: '''
  

Mime
View raw message