hi all..
i need some idea's & suggestion how to design a good postgresql table that occupied aspect as below:
1)there are 3 types of user which are admin, academic-staff & non-academic-staff.
2)academic-staff & non-academic staff can be flexsibally set their role one bye one whether can 'query,insert,update,delete' .
my difficulty is how to manage this on database & interface. I also stiill blur on how to relate the
postgress privilledge with my session...
as far as i'm concern the priviledge on postgresql is controling the user acessibillity on each table..so if in our system design there will be join in many table so how to set it....
tq in advance..
i need some idea's & suggestion how to design a good postgresql table that occupied aspect as below:
1)there are 3 types of user which are admin, academic-staff & non-academic-staff.
2)academic-staff & non-academic staff can be flexsibally set their role one bye one whether can 'query,insert,update,delete' .
my difficulty is how to manage this on database & interface. I also stiill blur on how to relate the
postgress privilledge with my session...
as far as i'm concern the priviledge on postgresql is controling the user acessibillity on each table..so if in our system design there will be join in many table so how to set it....
tq in advance..