Static vs Table Security

Top  Previous  Next

Static security is based on a fixed table (that can also be manually edited) that is kept with the dbQwikSite project.

 

The static approach is best when there is a low turnover in the people using the system and the roles and responsibilities do not change very often over time.

 

The dynamic approach is based on the maintenance of a security table and does not require modifications to the dbQwikSite project but rather on the maintenance of a database table, using any access method. The dynamic approach is recommended where the roles and responsibilities of the users change regularly or if there is a high turnover of system users.

 

The static approach requires security maintenance to be handled from within the dbQwikSite application while dynamic security can be managed both from within dbQwikSite or by using any database access tool.  The dynamic approach also requires security on who can access the database tables directly.