Design and Implementation of multi-user permission Control for Web application systems-database design [2]: multi-user permission Control

Design and Implementation of multi-user permission Control for Web application systems-database design [2]: multi-user permission Control

To build a Web permission Configuration System, you need the following five data tables: Personnel table, group table, page table, directory table, and Operation permission table. The IDS used in each data table are the IDs of auto-increment 1. The definitions of each data table are as follows:

1.1 Personnel table (operatorinfo)

1.2 grouping table (operatorgroup)

1.3 page table (pageinfo)

1.4 catalog)

1.5 permission list)

1.6 ing

User tables can be mapped to group tables by group numbers;

The page table can be mapped to the directory table through the directory number;

The group number, directory number, and page number are mapped to the permission table to determine the page that a user can access. A user can belong to multiple groups and has all permissions in the group.

Summary: This chapter mainly introduces the design of data tables. The next chapter describes how to build a project and how to encapsulate basic operations.