Home Projects Jobs Clientele Contact


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

UU Database

Hi All!
HSquirrel started database design page

Please review and comment.

From my side, I like the policies set in there, and agree to most
of them. I especially like access logging part, as for me it would
have only been an afterthought, which would be pain to implement
if it were added in the end. Only thing that I have my doubts about
is requirement for stored procedure language to have integrity
check. I suspect PostgreSQL doesn't support any such language.
We might end up writing our own validation tool eventually

Only only really questionable point is the last one - access roles.
What is meant  by that? The way I saw the secrity ACLs was just
separate access lists for each specific object, with whatever
rights granularity we want (i.e. - someone might have "read, comment"
rithgts, while someone else "read,solve" rights, etc...)
Role in this scenario could be just standart set of rights, for ease
of management. Is this what you meant, or is it something

Ilya A. Volynets-Evenbakh
Total Knowledge. CTO

Authoright © Total Knowledge: 2001-2008