content_image/727244.jpg
<img src='content_image/727244.jpg'>

## Static Privilege Descriptions 

Static privileges are built in to the server, in contrast to dynamic privileges, which are defined at runtime. The following list describes each static privilege available in MySQL. 

Particular SQL statements might have more specific privilege requirements than indicated here. If so, the description for the statement in question provides the details. 

• ALL , ALL PRIVILEGES 

These privilege specifiers are shorthand for “all privileges available at a given privilege level”  (except GRANT OPTION ). For example, granting ALL  at the global or table level grants all global privileges or all table-level privileges, respectively. 

• ALTER 

Enables use of the ALTER TABLE  statement to change the structure of tables. ALTER TABLE  also requires the CREATE  and INSERT  privileges. Renaming a table requires ALTER  and DROP  on the old table, CREATE , and INSERT  on the new table. 

