List:General Discussion« Previous MessageNext Message »
From:Célio Cidral Junior Date:February 7 2006 9:46pm
Subject:Re: How to create an application for managing users
View as plain text  
Thank you Shawn!

2006/2/7, SGreen@stripped <SGreen@stripped>:
>
>
> Célio Cidral Junior <ccidral.newsbox@stripped> wrote on 02/05/2006
> 02:20:48
> PM:
>
> There already IS a users table that you can either send CRUD statements to
> or manage through the GRANT and REVOKE statements. Since MySQL security also
> gets down to the column level, there is a table for each level of user
> permissions: user, db, tables_priv, and columns_priv. The appropriate
> records and settings in those tables determines the access rights (the ACL)
> for native MySQL user accounts.
>
> Because these are "system" tables, they are not guaranteed to exist from one
> version to another nor are the columns' names or purposes guaranteed to stay
> the same between releases. You can directly edit them as you see fit but you
> must remember to issue a FLUSH PRIVILEGES command in order for your changes
> to take immediate effect.
>
> The parts of the manual pertinent to your task:
>
> http://dev.mysql.com/doc/refman/4.1/en/security.html
> http://dev.mysql.com/doc/refman/4.1/en/privilege-system.html
> http://dev.mysql.com/doc/refman/4.1/en/user-account-management.html
> http://dev.mysql.com/doc/refman/4.1/en/account-management-sql.html
>
> Shawn Green
>  Database Administrator
>  Unimin Corporation - Spruce Pine
Thread
How to create an application for managing usersCélio Cidral Junior4 Feb
  • Re: How to create an application for managing usersPeter Brawley4 Feb
Re: How to create an application for managing usersCélio Cidral Junior5 Feb
  • Re: How to create an application for managing usersSGreen7 Feb
    • Re: How to create an application for managing usersCélio Cidral Junior7 Feb