Databases Reference
In-Depth Information
Editing a User
The page used to edit a user appears after a user's creation, or whenever we click
Edit
for a user in the
User overview
page. There are four sections on this page,
each with its own
Go
button, so each section is operated independently and has a
distinct purpose.
Edit Privileges
The section for editing the user's privileges has the same look as the
Add a new User
dialog, and is used to view and to change global privileges.
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
ield
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.
Search WWH ::
Custom Search