![background image](http://html1.mh-extra.com/html/oracle/5-0/5-0_reference-manual_16461961172.webp)
Account Management Statements
1152
However, if an account named in a
GRANT
statement does not already exist,
GRANT
may create it
under the conditions described later in the discussion of the
NO_AUTO_CREATE_USER
[536]
SQL
mode.
The
REVOKE
statement is related to
GRANT
and enables administrators to remove account privileges.
See
Section 13.7.1.5, “
REVOKE
Syntax”
.
When successfully executed from the
mysql
program,
GRANT
responds with
Query OK, 0
rows affected
. To determine what privileges result from the operation, use
SHOW GRANTS
. See
Section 13.7.5.17, “
SHOW GRANTS
Syntax”
.
There are several aspects to the
GRANT
statement, described under the following topics in this section:
•
Privileges Supported by MySQL
•
Global Privileges
•
Database Privileges
•
Table Privileges
•
Column Privileges
•
Stored Routine Privileges
•
Account Names and Passwords
•
Other Account Characteristics
•
MySQL and Standard SQL Versions of
GRANT
Important
Some releases of MySQL introduce changes to the structure of the grant tables
to add new privileges or features. Whenever you update to a new version of
MySQL, you should update your grant tables to make sure that they have the
current structure so that you can take advantage of any new capabilities. See
Section 4.4.9, “
mysql_upgrade
— Check Tables for MySQL Upgrade”
.
Privileges Supported by MySQL
The following table summarizes the permissible
priv_type
privilege types that can be specified
for the
GRANT
and
REVOKE
statements. For additional information about these privileges, see
Section 6.2.1, “Privileges Provided by MySQL”
.
Table 13.1. Permissible Privileges for
GRANT
and
REVOKE
Privilege
Meaning
ALL [PRIVILEGES]
[576]
Grant all privileges at specified access level except
GRANT
OPTION
[577]
ALTER
[576]
Enable use of
ALTER TABLE
ALTER ROUTINE
[576]
Enable stored routines to be altered or dropped
CREATE
[576]
Enable database and table creation
CREATE ROUTINE
[576]
Enable stored routine creation
CREATE TEMPORARY
TABLES
[576]
Enable use of
CREATE TEMPORARY TABLE
CREATE USER
[576]
Enable use of
CREATE USER
,
DROP USER
,
RENAME USER
, and
REVOKE ALL PRIVILEGES
CREATE VIEW
[577]
Enable views to be created or altered
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...