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 Fri, 18 Aug 2006 02:58:39 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

------------------------------------------------------------------------------
  ||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. ||
- ||CREATE TRIGGER statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj43125.html
HTML URL] || Yip || The statement "You can create a trigger in any schema except one that
starts with SYS." is not longer true when sql authorization is enabled.  Need to update this
statement to reflect on the Derby SQL authorization model. ||
+ ||CREATE TRIGGER statement || [http://db.apache.org/derby/docs/dev/ref/rrefsqlj43125.html
HTML URL] || Yip || The statement "You can create a trigger in any schema except one that
starts with SYS." is no longer true when sql authorization is enabled.  Need to update this
statement to reflect on the Derby SQL authorization model. ||
  
  [[Anchor(sqlreservedwords)]]'''SQL Reserved Words: '''
  

Mime
View raw message