Am 10.03.2014 15:34, schrieb Tanstaafl: > On 3/10/2014 9:42 AM, Sergei Golubchik <[email protected]> wrote: >> Hi, Tanstaafl! >> >> On Mar 09, Tanstaafl wrote: >>> So, as things stand now, I'm going to have to manually add every >>> single individual userid to every single resource they will need to >>> have access too, rather than just doing this with groups. > >> This is what SQL standard roles were designed to solve. >> We have implemented roles in 10.0. >> You create roles instead of groups, and grant these roles to users. > > Hi Sergei, > > thanks for the reply, but you are misunderstanding. > > I am *not* talking about *SQL* users - ie, users who will have direct access > to and be interacting with the SQL > database. > > I am talking about the EMAIL users that postfixadmin creates and stores in > the sql db. > > This is what I meant when I said 'in the same way as Active Directory > (Security) Groups work'... > > So, I need an SQL schema that allows for the creation of 'Groups', that the > email 'accounts' can be made members > of, that can then be queried to test if any given email user is a member of > any given group. > > Hopefully that was a little clearer
that is hardly a mariadb topic you need to ask that on a postfixadmin list
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
