user level

[Anon]

I have a table for staff and student.
Staff may access ALL the links/pages in web while the student are restricted to
certain pages ONLY.

How am i suppose to that?
(database design ++)

[flipis]

If using MySQL, in the table mysql you have all of the tabled you need to set restrictions tom users. You can give certain privileges to one user and others to some other user.

In other DB systems, like MSSQL Server 2000, the GUI has a help system explaining very deeply how to set up permissions.

Hope it helps

fLIPIS

[Anon]

Currently i'm using postgresql.
How to do it with this db.

[flipis]

Sorry, never used it. But it must not be that hard, anyway.

[djurnoce]

Use sessions (a PHP function) to track a user from page to page (after she has logged in already), and only display certain things based upon the users level of access (grabbed from the same database when you check their login/password)