Project

General

Profile

Tâche #17503

Scénario #17555: Evolutions eole-postgresql

permettre l'attribution de droits ALL à plusieurs rôles

Added by Vincent Chavanon over 3 years ago. Updated about 3 years ago.

Status:
Fermé
Priority:
Normal
Assigned To:
Start date:
10/13/2016
Due date:
% Done:

100%

Estimated time:
2.00 h
Spent time:
Remaining (hours):
0.0

Description

la syntaxe admise pour un grant, selon la doc postgres :

GRANT { { CREATE | CONNECT | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] } ON DATABASE database_name [, ...] TO { [ GROUP ] role_name | PUBLIC } [, ...] [ WITH GRANT OPTION ]

donc soit on utilise une liste de privilèges séparés par des virgules, soit on utilise ALL, mais ALL ne peut pas faire partie d'une liste.

On pourrait, dans /usr/lib/python2.7/dist-packages/eoledb/eoledbpg.py ligne 266 faire une boucle sur param['privileges'] au lieu d'un ', '.join(param['privileges'])

Associated revisions

Revision de4f3a86 (diff)
Added by Vincent Chavanon over 3 years ago

pouvoir donner des droits sur toutes les bases Ref:#17503

History

#1 Updated by Thierry Bertrand over 3 years ago

  • Assigned To set to Vincent Chavanon
  • Target version set to sprint 2016 42-44 - Équipe PNE-SR
  • Parent task set to #17555

#2 Updated by Thierry Bertrand over 3 years ago

  • Description updated (diff)
  • Estimated time set to 2.00 h
  • Remaining (hours) set to 2.0

#3 Updated by Vincent Chavanon over 3 years ago

  • Status changed from Nouveau to Résolu

#4 Updated by Vincent Chavanon over 3 years ago

  • Remaining (hours) changed from 2.0 to 0.25

#5 Updated by Joël Cuissinat about 3 years ago

  • % Done changed from 0 to 100

#6 Updated by Thierry Bertrand about 3 years ago

  • Status changed from Résolu to Fermé
  • Remaining (hours) changed from 0.25 to 0.0

Also available in: Atom PDF