AO Logo
 
  
  
  
MySQL DB Users
AO
AO Industries, Inc.
Application Infrastructure ProviderApplication Infrastructure Provider
Sign UpWhat's NewClient AreaContact UsSite Map
 
your location:   home page ··· aoserv platform ··· software components ··· aoserv client ··· tables ··· table definitions ··· mysql db users

TABLE NAME

mysql_db_users

DESCRIPTION

The mysql_db_users table stores which mysql_server_users can access which mysql_databases. The user permissions are also contained in each row.

COLUMNS

columntypenulluniquereferencesreferenced_bysince_versiondescription
pkeypkeyfalsetrue1.0a100a generated primary key
mysql_databasefkeyfalsefalsemysql_databases.pkey1.0a100the pkey in mysql_databases
mysql_server_userfkeyfalsefalsemysql_server_users.pkey1.31the pkey in mysql_server_users
select_privbooleanfalsefalse1.0a100the SELECT privilege
insert_privbooleanfalsefalse1.0a100the INSERT privilege
update_privbooleanfalsefalse1.0a100the UPDATE privilege
delete_privbooleanfalsefalse1.0a100the DELETE privilege
create_privbooleanfalsefalse1.0a100the CREATE privilege
drop_privbooleanfalsefalse1.0a100the DROP privilege
grant_privbooleanfalsefalse1.0a100the GRANT privilege
references_privbooleanfalsefalse1.0a100the REFERENCES privilege
index_privbooleanfalsefalse1.0a100the INDEX privilege
alter_privbooleanfalsefalse1.0a100the ALTER privilete
create_tmp_table_privbooleanfalsefalse1.0a111the Create_tmp_table_priv
lock_tables_privbooleanfalsefalse1.0a111the Lock_tables_priv
create_view_privbooleanfalsefalse1.4the Create_view_priv
show_view_privbooleanfalsefalse1.4the Show_view_priv
create_routine_privbooleanfalsefalse1.4the Create_routine_priv
alter_routine_privbooleanfalsefalse1.4the Alter_routine_priv
execute_privbooleanfalsefalse1.4the Execute_priv
event_privbooleanfalsefalse1.54the Event_priv
trigger_privbooleanfalsefalse1.54the Trigger_priv