[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
UU Database
Hi All!
HSquirrel started database design page
(http://www.total-knowledge.com/wiki/index.php/UU_Database).
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
instead.
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
different?
--
Ilya A. Volynets-Evenbakh
Total Knowledge. CTO
http://www.total-knowledge.com