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