linux-traipu team mailing list archive

[Daniel Nichter <daniel@xxxxxxxxxxx>]

There seems to be an internal difference, too, at least for whether it's
DATA_DICTIONARY or data_dictionary:

drizzle> show schemas;
ERROR 1044 (42000): Access denied for user 'daniel' to schema 'data_dictionary'

drizzle> use DATA_DICTIONARY;
Schema changed

drizzle> show tables;
ERROR 1044 (42000): Access denied for user 'daniel' to schema 'data_dictionary'

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/956153

Title:
  regex_policy patterns are case-senstive

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  Confirmed

Bug description:
  regex_policy plugin patterns are case-senstive but Drizzle is not
  case-senstive.

  To reproduce:

  1. create schema daniel
  2. Use policy "daniel schema=daniel ACCEPT"
  3. Login user=daniel and schema appears, OK, but...
  4. Use policy "daniel schema=DANIEL ACCEPT" _or_ "DANIEL schema=daniel ACCEPT"
  5. Login user=daniel and schema does not appear

  Suggested fix: make all patterns case-insenstive by default.  Maybe
  add an option: --regex-policy.case-senstive if there's a need for
  case-sensitivity?

  Partial workaround:

  daniel schema=daniel ACCEPT
  daniel schema=DANIEL ACCEPT

  That doesn't cover schema=Daniel, schema=DaNiEl, etc.

To manage notifications about this bug go to:
https://bugs.launchpad.net/drizzle/+bug/956153/+subscriptions