/************************************************
 * a simple experiment to create an analogon to *
 * oracle's role.				*
 *						*
 * !this isn't in use yet!			*
 ************************************************/

create table role {
	role smallint, -- analog group of users
	name text
}

create table permission { -- link role with pg_user
	uid integer references pg_user(usesysid),
	role smallint references role
}
