wjgilmore.com. Furthermore, keep in mind that MySQL will always apply the
most specific set of permissions that matches the supplied user@host combination. Although this
may seem obvious, sometimes unforeseen consequences can happen. For example, it??™s often the
case that multiple rows match the requesting user/host identity; even if a wildcard entry that satisfies
the supplied user@host combination is seen before a later entry that perfectly matches the
identity, the privileges corresponding to that perfect match will be used instead of the wildcard
match. Therefore, always take care to ensure that the expected privileges are indeed supplied for
each user. Later in this chapter, you??™ll see how to view privileges on a per-user basis.
The Privilege Columns
The next 28 columns listed in Table 29-1 comprise the user privilege columns. Keep
in mind that these are representative of the user??™s global privileges when discussed in
the context of the user table.
??? Select_priv: Determines whether the user can select data via the SELECT
command.
??? Insert_priv: Determines whether the user can insert data via the INSERT
command.
??? Update_priv: Determines whether the user can modify existing data via the
UPDATE command.
??? Delete_priv: Determines whether the user can delete existing data via the
DELETE command.
??? Create_priv: Determines whether the user can create new databases and tables.
Pages:
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853