linux-traipu team mailing list archive

[Daniel Nichter <daniel@xxxxxxxxxxx>]

Public bug reported:

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.

** Affects: drizzle
     Importance: Undecided
         Status: Confirmed


** Tags: case-sensitivity regex-policy-plugin

-- 
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