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 "SqlRoles" by DagWanvik
Date Thu, 01 Feb 2007 18:36: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 DagWanvik:
http://wiki.apache.org/db-derby/SqlRoles

------------------------------------------------------------------------------
- = SQL Roles for Derby =
- 
  Some thoughts towards fashioning SQL roles for Derby. Feel free to
  pick up on this, I won't be able to address it more for a
  while. -''Dag''
  
  [[TableOfContents]]
  
- == SQL model ==
+ = SQL model =
  
  The SQL 2003 standard (IEC/ISO 9075-2-2003; if you don't have access
  to the standard, this link contains an almost identical draft:
@@ -73, +71 @@

  Virginia.
  http://csrc.nist.gov/rbac/RBAC_DBMS_Comparison.pdf
  
- == Language elements ==
+ = Language elements =
  Section and page references arfe to IEC/ISO 9075-2-2003.
  
  ||    <role definition>   ("CREATE ROLE") || 12.4, page 741 ||
@@ -85, +83 @@

  
  
  
- == Roles name space ==
+ = Roles name space =
  
  In SQL, role names live in the same name space as user names. Since
  Derby has pluggable user authentication (there is no user catalog in
@@ -109, +107 @@

  first?
  
  
- == Some other issues ==
+ = Some other issues =
  
  * Who should be able to create roles? Only database owner? All?  SQL
  says the privilege required to create roles is implementation

Mime
View raw message