<< previous page   --   table of contents   --   next page >>
| | | | | | | |
  • Return to Table of Contents
    • Table of Contents
    1. General Information
    2. MySQL Installation
    3. Tutorial Introduction
    4. Database Administration
    5. MySQL Optimisation
    6. MySQL Language Reference
    7. MySQL Table Types
    8. MySQL APIs
    9. Extending MySQL
    198 MySQL Technical Reference for Version 4.0.3 The server uses the user, db, and host tables in the mysql database at both stages of access control.  The elds in these grant tables are shown here: Table name user db host Scope elds Host Host Host User Db Db Password User Privilege elds Select_priv Select_priv Select_priv Insert_priv Insert_priv Insert_priv Update_priv Update_priv Update_priv Delete_priv Delete_priv Delete_priv Index_priv Index_priv Index_priv Alter_priv Alter_priv Alter_priv Create_priv Create_priv Create_priv Drop_priv Drop_priv Drop_priv Grant_priv Grant_priv Grant_priv References_ priv Reload_priv Shutdown_ priv Process_priv File_priv For the second stage of access control (request veri cation), the server may, if the request involves tables, additionally consult the tables_priv and columns_priv tables.  The elds in these tables are shown here: Table name tables_priv columns_priv Scope elds Host Host Db Db User User Table_name Table_name Column_name Privilege elds Table_priv Column_priv Column_priv Other elds Timestamp Timestamp Grantor Each grant table contains scope elds and privilege elds. Scope   elds  determine  the  scope  of  each  entry  in  the  tables,  that  is,  the  context  in which the entry applies.   For example,  a  user  table entry with  Host  and  User  values of 'thomas.loc.gov'  and  'bob'  would be used for authenticating connections made to the server by bob from the host thomas.loc.gov.  Similarly, a db table entry with Host, User, and Db  elds of 'thomas.loc.gov', 'bob' and 'reports' would be used when bob connects from  the  host  thomas.loc.gov  to  access  the  reports  database.   The  tables_priv  and
     

    Customer Support CentreMySQL Reference Manual

    Web Hosting Services
    UNIX WEB HOSTING
    MERCHANT ACCOUNTS
    DEDICATED SERVERS
    E-COMMERCE HOSTING
    SUPPORT & FAQ's
    TERMS OF USE
    Domain Services
    DOMAIN
    REGISTRATION
    MANAGE
    YOUR ACCOUNT
    SUPPORT & FAQ's
    TERMS OF USE
    Corporate Info
    ABOUT US
    OUR NETWORK
    CONTACT US
    SITE MAP
    UNIX Web Hosting | Merchant Accounts | Dedicated Hosting | E-Commerce Hosting
    Domain Registration | About Us | Our Network | Contact Us | Site Map
    Our Partners
    Copyright © 2002 Dyntex Group, Inc. All Rights Reserved
  • Return to Table of Contents
    		•
  • Back to top
    • Web Hosting: Manuals & FAQ's
    1. Unix-Based Web Hosting
    2. Unix Dedicated Servers
    3. Windows Dedicated Servers
    4. CuteFTP User’s Guide
    5. CuteHTML User’s Guide
    6. WS_FTP Pro User's Guide
    7. Miva Order User's Guide
    8. Miva Merchant User's Guide