I have Database with users level access. intend to limit authentication to some users from a certain date.Example: from the 1st of November he not access the system, only the Admin
how can i make it works?
The method you use will depend on exactly how you want the system to behave. Do you want the user to be able to enter the database and just be able to read the data, enter the database and not be able to read data, or not be able to enter the database at all?
i thinking of 2º option. although searching for a solution, I am glad to know that there are other options. if you dont mind to explain... how do i start?
I have Database with users level access. intend to limit authentication to some users from a certain date.
Example: from the 1st of November he not access the system, only the Admin
Under the Security menu (File->Manage->Security) look for privilege sets. You want to control access to users. Every user is assigned a privilege set. Access to the data is controlled through the privilege set config.
If you want to stop access to all users of that group on the same date you can put the calculation directly into the access privileges. You allow access to the system when:
get(currentdate) < date(1 ; 11 ; 2012)
If you want to give each user a different date at which access stops you need to create a field which controls access, label it clearly, eg, "access allowed". Put the end date into that field:
get(currentdate) < users::access allowed
Thanks, Malcom. I've been away from the computer and couldn't answer immediately.
To expand on Malcom's correct answer: You'll need to set access on each table in the database you want to restrict in this fashion. You can't just do it globally.
Retrieving data ...