From: Andreas <maps.on@gmx.net>
To: pgsql-sql@postgresql.org
Subject: How to cascade information like the user roles ?
Date: Tue, 19 Jan 2010 01:33:55 +0100
Message-ID: <4B54FDF3.4070601@gmx.net> (raw)
Hi,
I need something like the user-roles of PG to store options of my users.
I guess i need a table with roles, options and one that stores the
refernces from roles to options.
roles (role_id, role_name)
option (option_id, option_name)
role_has_option (role_fk, option_fk)
so far is easy. Now I can let role1 have option1 and option2 ...
But I'd further like to let role2 inherit role1's options and also have
option3.
role_inherits_role (parent_role_fk, child_role_fk)
1, 2
What SELECT would deliver all options for role2 inkluding the inherited
ones?
like
role_id, option_id
2, 1
2, 2
2, 3
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: maps.on@gmx.net
Subject: Re: How to cascade information like the user roles ?
In-Reply-To: <4B54FDF3.4070601@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox