There is a need for a network administrator to add data to the warehouse, but can not let him casually add, all of his added data will need to pass the Super Administrator's audit to really add to the database .... How do you want to achieve this function, give some ideas ....
Reply to discussion (solution)
Data added or added to the library, except for information that should be added (such as a user ID)
The table also needs to set a field that identifies whether the audit
In this way, only audited data are considered official data.
Data added or added to the library, except for information that should be added (such as a user ID)
The table also needs to set a field that identifies whether the audit
In this way, only audited data are considered official data.
is added to the database, according to your meaning to add a field dedicated to whether or not to be audited, what is the way to be in the Super administrator a login to remind him how many data needs to be audited ....
Audit field Audit Initial value is 0, by 1
So
Sekect * from Tbl_name where audit=0
is a record of all the failed audits