Databases Reference
In-Depth Information
Assigning database-specific privileges
In this section, we define the databases to which our user has access, and his or her
exact privileges on these databases.
As shown in the previous screenshot, we see
None
because we haven't defined any
privileges yet. There are two ways of defining database privileges. First, we can
choose one of the existing databases from the drop-down menu as shown in the
following screenshot:
This assigns privileges only for the chosen database. Secondly, we can also
choose
Use text field:
and enter a database name. We could enter a non-existent
database name, so that the user can create it later (provided we give him/her the
CREATE
privilege in the next panel). We can also use special characters, such as the
underscore and the percent sign, for wildcards.
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
and click on
Go
.
The next screen is used to set
bill
is privileges on the
bill
database, and create table-
specific privileges.
Search WWH ::
Custom Search