Scratch Pad

Temporary notes/lists

Custom Window Wells

Colorado Custom Window Wells, LLC
303-682-9500
www.CustomWindowWells.com

Measurements: 52" wide, 58" high, 25.5" depth

MySQL Grants

Grant Priv me App
CREATE (Create_priv) db Y ?
CREATE (Create_priv) table
Required for:
* ALTER TABLE
* Renaming table (on new table name)
Y ?
CREATE (Create_priv) index Y ?
DROP (Drop_priv) db
Dangerous on mysql
Y ?
DROP (Drop_priv) table
Required for:
* Renaming table (on old table name)
* ALTER TABLE … DROP PARTITION on partitioned table
* TRUNCATE TABLE
Y ?
DROP (Drop_priv) view Y ?
GRANT OPTION (Grant_priv) db Y ?
GRANT OPTION (Grant_priv) table Y ?
GRANT OPTION (Grant_priv) stored routine Y ?
LOCK TABLES (Lock_tables_priv) db Y ?
REFERENCES (References_priv) db
Unused
REFERENCES (References_priv) table
Unused
EVENT (Event_priv) db
Required to create, alter, drop, or see events
for the Event Scheduler
ALTER (Alter_priv) table
Also requires CREATE and INSERT for tables.
Required for:
* Renaming table (on both old and new name)
Y
DELETE (Delete_priv) table
(Privilege to delete rows of table)
Y
INDEX (Index_priv) table
(Create/Drop indexes of existing table)
Y
INSERT (Insert_priv) table
(Privilege to insert rows to table)
Required for:
* ALTER TABLE
* Renaming table (on new table name)
* ANALYZE TABLE
* OPTIMIZE TABLE
* REPAIR TABLE
Y
INSERT (Insert_priv) column Y
SELECT (Select_priv) table Y
SELECT (Select_priv) column Y
UPDATE (Update_priv) table Y
UPDATE (Update_priv) column Y
CREATE TEMPORARY TABLES (Create_tmp_table_priv) table Y ?
TRIGGER (Trigger_priv) table
(Create/Drop/Execute triggers of a table)
Y ?
CREATE VIEW (Create_view_priv) view Y
SHOW VIEW (Show_view_priv) view Y
ALTER ROUTINE (Alter_routine_priv) stored routine
(Alter/Drop stored routines)
Y ?
CREATE ROUTINE (Create_routine_priv) stored routine Y ?
EXECUTE (Execute_priv) stored routine Y ?
FILE (File_priv) file access on server
Dangerous (see secure_file_priv)
Required for:
* LOAD DATA INFILE
* SELECT … INTO OUTFILE
* LOAD_FILE()
CREATE TABLESPACE (Create_tablespace_priv) admin
(Create/Alter/Drop tablespaces and log file groups)
CREATE USER (Create_user_priv) admin
Required for:
* CREATE USER
* DROP USER
* RENAME USER
* REVOKE ALL PRIVILEGES
Y ?
PROCESS (Process_priv) admin
Required for:
* SHOW PROCESSLIST
* mysqladmin processlist
* SHOW ENGINE
Y ?
PROXY (see proxies_priv table) admin
(Proxy Users)
N N
RELOAD (Reload_priv) admin
(Flush/Refresh/Reload grant tables, log files, etc.)
Y N
REPLICATION CLIENT (Repl_client_priv) admin N N
REPLICATION SLAVE (Repl_slave_priv) admin N N
SHOW DATABASES (Show_db_priv) admin Y ?
SHUTDOWN (Shutdown_priv) admin
Dangerous
N N
SUPER (Super_priv) admin
Dangerous
Required for:
* kill threads belonging to other accounts
* SET GLOBAL to modify global settings
* mysqladmin debug
* overriding read_only to perform updates
* etc.
N N
ALL [PRIVILEGES] () admin
(Grants all privileges - except GRANT OPTION -
at given privilege level, e.g. table-level)
N N
USAGE () admin
(Modify account attributes such as resource
limits or SSL characteristics)
N N

8x8 "maze"

#T# ### ### #S# #?# ### ### #T#
### ### ### #*# ### ### ### ###
### ### ### #?# ### ### ### ###
#?# ### ### ### ### #?# #*# #S#
#S# #*# #?# ### ### ### ### #?#
### ### ### ### #?# ### ### ###
### ### ### ### #*# ### ### ###
#T# ### ### #?# #S# ### ### #T#

4 shapes

  • White Square (U+25A1): □
  • White Triangle (U+25B3): △
  • White Diamond (U+25C7): ◇
    • Lozenge (U+25CA): ◊
  • White Circle (U+25CB): ○

Sandbox

Direct style: TBD

Theme CSS: TBD

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License