Database Reference
In-Depth Information
▼
Analysis
This
REVOKE
statement takes away the
SELECT
access just granted to user
bforta
. The access being revoked must exist or an error will be thrown.
GRANT
and
REVOKE
can be used to control access at several levels:
Entire server, using
GRANT ALL
and
REVOKE ALL
■
Entire database, using
ON database.*
■
Specific tables, using
ON database.table
■
Specific columns
■
Specific stored procedures
■
Table 28.1 lists each of the rights and privileges that may be granted or
revoked.
Table 28.1
Rights and Privileges
Privilege
Description
ALL
All privileges except
GRANT OPTION
.
ALTER
Use of
ALTER TABLE
.
ALTER ROUTINE
Use of
ALTER PROCEDURE
and
DROP
PROCEDURE
.
CREATE
Use of
CREATE TABLE
.
CREATE ROUTINE
Use of
CREATE PROCEDURE
.
CREATE TEMPORARY TABLES
e f
CREATE TEMPORARY TABLE
.
Use of
CREATE USER
,
DROP USER
,
RENAME
USER
, and
REVOKE ALL PRIVILEGES
.
CREATE USER
Use of
CREATE VIEW
.
CREATE VIEW
Use of
DELETE
.
DELETE
Use of
DROP TABLE
.
DROP
Use of
CALL
and stored procedures.
EXECUTE
Use of
SELECT INTO OUTFILE
and
LOAD
DATA INFILE
.
FILE
Use of
GRANT
and
REVOKE
.
GRANT OPTION
Use of
CREATE INDEX
and
DROP INDEX
.
INDEX
Use of
INSERT
.
INSERT
Use of
LOCK TABLES
.
LOCK TABLES
Use of
SHOW FULL PROCESSLIST
.
PROCESS
Use of
FLUSH
.
RELOAD
Access to location of servers.
REPLICATION CLIENT
Used by replication slaves.
REPLICATION SLAVE
Use of
SELECT
.
SELECT