In message <[EMAIL PROTECTED]>, edcasati <[EMAIL PROTECTED]>
writes
>Made some more progress today, to the point where I need to start
>thinking about another necessary feature: security. How to require
>login, and then allow different people to have different rights (edit
>/ create / view only). For example, allowing an employee to login and
>view only records that pertain to him/her.
It is possible to restrict rights in SQL, but normally it is done in
PHP.
A user table has username, password, youcandothis, youcandothat,
youcandotheother. When the user logs in, the password is checked, and
it just a case of "if youcandothis {..."
--
Pete Clark
http://www.hotcosta.com
http://www.spanishholidaybookings.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/CefplB/TM
--------------------------------------------------------------------~->
The php_mysql group is dedicated to learn more about the PHP/MySQL web database
possibilities through group learning.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/php_mysql/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/