Database-Specific Privileges
In this section, we define the databases to which our user has access, and his or her
exact privileges. Currently, we see None because we haven't defined any. There are
two ways of defining database privileges. First, we can choose one of the existing
databases from the drop-down menu:
This assigns privileges only for the chosen database. We can also choose Use text
field and enter a database name. We could insert a non-existent database name here
so that this user can create it later (provided we give him or her the CREATE privilege
in the next panel), or we could use special characters like the underscore and the
percent sign for wildcards.
Chapter 19
[ 287 ]
For example, entering bill here would enable him to create a bill database, and
entering bill% would enable him to create a database with any name that starts
with bill. For our example, we will enter bill.
The next screen is used to set bill's privileges on the bill database and create
table-specific privileges.
To learn more about the meaning of a specific privilege, we can move the mouse over
a privilege name (which is always in English) and an explanation about this privilege
appears in the current language. We give SELECT, INSERT, UPDATE, DELETE,
CREATE, ALTER, INDEX, and DROP privileges to bill on this database, and
click Go.
Pages:
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262