On 1/19/07, Rick Hillegas <[EMAIL PROTECTED]> wrote:
Hi David,
This is a possibility. It seems to me that "." is a bad choice for
customers whose usernames take the form "firstName.lastName". And "@" is
bad for customers whose usernames are email addresses. And "-", "_", " "
can all turn up in usernames too. And "~", "?", "=", ":", "/", "\" are
all awkward if the databasename is an url or a path. Would "!", "#",
"*", "+", "|", ";" be better?
Permissions can have multiple string parameters, why not separate the
username and database name into separate arguments, then you don't
have to worry about escaping. e.g.:
# this is a systemWideID
grant principal org.apache.derby.authentication.DatabasePrincipal "fred" ""
# this is a databaseScopedID
grant principal org.apache.derby.authentication.DatabasePrincipal
"[EMAIL PROTECTED]" "fredsDB"
andrew
