= Crie o usuário "zpush" no banco de dados do Expresso = [[PageOutline(1-3, Conteúdo)]] {{{ revoke zpush_role from zpush; drop user zpush; revoke all privileges on phpgw_async from zpush_role; revoke all privileges on phpgw_categories from zpush_role; revoke all privileges on phpgw_config from zpush_role; revoke all privileges on seq_phpgw_cal from zpush_role; revoke all privileges on seq_phpgw_categories from zpush_role; revoke all privileges on seq_phpgw_cc_groups from zpush_role; revoke all privileges on seq_phpgw_addressbook from zpush_role; revoke all privileges on phpgw_cal from zpush_role; revoke all privileges on phpgw_cal_extra from zpush_role; revoke all privileges on phpgw_cal_holidays from zpush_role; revoke all privileges on phpgw_cal_repeats from zpush_role; revoke all privileges on phpgw_cal_user from zpush_role; revoke all privileges on phpgw_cc_contact from zpush_role; revoke all privileges on phpgw_cc_addresses from zpush_role; revoke all privileges on phpgw_cc_city from zpush_role; revoke all privileges on phpgw_cc_company from zpush_role; revoke all privileges on phpgw_cc_company_addrs from zpush_role; revoke all privileges on phpgw_cc_company_conns from zpush_role; revoke all privileges on phpgw_cc_company_legals from zpush_role; revoke all privileges on phpgw_cc_company_rels from zpush_role; revoke all privileges on phpgw_cc_connections from zpush_role; revoke all privileges on phpgw_cc_contact_addrs from zpush_role; revoke all privileges on phpgw_cc_contact_company from zpush_role; revoke all privileges on phpgw_cc_contact_conns from zpush_role; revoke all privileges on phpgw_cc_contact_grps from zpush_role; revoke all privileges on phpgw_cc_contact_rels from zpush_role; revoke all privileges on phpgw_cc_groups from zpush_role; revoke all privileges on phpgw_cc_prefixes from zpush_role; revoke all privileges on phpgw_cc_state from zpush_role; revoke all privileges on phpgw_cc_status from zpush_role; revoke all privileges on phpgw_cc_suffixes from zpush_role; revoke all privileges on phpgw_cc_typeof_co_addrs from zpush_role; revoke all privileges on phpgw_cc_typeof_co_conns from zpush_role; revoke all privileges on phpgw_cc_typeof_co_legals from zpush_role; revoke all privileges on phpgw_cc_typeof_co_rels from zpush_role; revoke all privileges on phpgw_cc_typeof_ct_addrs from zpush_role; revoke all privileges on phpgw_cc_typeof_ct_conns from zpush_role; revoke all privileges on phpgw_cc_typeof_ct_rels from zpush_role; revoke all privileges on FUNCTION phpgw_cal_zpush() from zpush_role; revoke all privileges on FUNCTION phpgw_cal_repeats_zpush() from zpush_role; drop role zpush_role; create user zpush; alter user zpush with password 'zpush'; create role zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_async to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_categories to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_config to zpush_role; grant all privileges on seq_phpgw_cal to zpush_role; grant all privileges on seq_phpgw_categories to zpush_role; grant all privileges on seq_phpgw_cc_groups to zpush_role; grant all privileges on seq_phpgw_addressbook to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cal to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cal_extra to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cal_holidays to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cal_repeats to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cal_user to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_contact to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_addresses to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_city to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_company to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_company_addrs to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_company_conns to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_company_legals to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_company_rels to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_connections to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_contact_addrs to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_contact_company to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_contact_conns to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_contact_grps to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_contact_rels to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_groups to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_prefixes to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_state to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_status to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_suffixes to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_typeof_co_addrs to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_typeof_co_conns to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_typeof_co_legals to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_typeof_co_rels to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_typeof_ct_addrs to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_typeof_ct_conns to zpush_role; grant SELECT, INSERT, UPDATE, DELETE on phpgw_cc_typeof_ct_rels to zpush_role; grant zpush_role to zpush; }}}