-- User Grants Export
-- Generated on 2025-12-12 08:16:22

-- Grants for 'Jdobbs'@'%'
GRANT SELECT, UPDATE, DROP ON *.* TO `Jdobbs`@`%`;
REVOKE UPDATE, DROP ON `mysql`.* FROM `Jdobbs`@`%`;
REVOKE DROP ON `mysql_audit`.* FROM `Jdobbs`@`%`;
REVOKE DROP ON `sys`.* FROM `Jdobbs`@`%`;

-- Grants for 'Jlcreer'@'%'
GRANT USAGE ON *.* TO `Jlcreer`@`%`;

-- Grants for 'Jpennacchio'@'%'
GRANT SELECT, UPDATE, DROP ON *.* TO `Jpennacchio`@`%`;
REVOKE UPDATE, DROP ON `mysql`.* FROM `Jpennacchio`@`%`;
REVOKE DROP ON `mysql_audit`.* FROM `Jpennacchio`@`%`;
REVOKE DROP ON `sys`.* FROM `Jpennacchio`@`%`;

-- Grants for 'Sample'@'%'
GRANT USAGE ON *.* TO `Sample`@`%`;

-- Grants for 'Steph_readonly'@'%'
GRANT SELECT ON *.* TO `Steph_readonly`@`%`;

-- Grants for 'administrator'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE ROLE, DROP ROLE ON *.* TO `administrator`@`%` WITH GRANT OPTION;
GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ADMIN,BACKUP_ADMIN,CONNECTION_ADMIN,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,REPLICATION_APPLIER,ROLE_ADMIN,SHOW_ROUTINE,XA_RECOVER_ADMIN ON *.* TO `administrator`@`%` WITH GRANT OPTION;
GRANT CREATE TEMPORARY TABLES ON `sys`.* TO `administrator`@`%` WITH GRANT OPTION;
REVOKE INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `mysql`.* FROM `administrator`@`%`;
REVOKE CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `mysql_audit`.* FROM `administrator`@`%`;
REVOKE CREATE, DROP, REFERENCES, INDEX, ALTER, LOCK TABLES, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `sys`.* FROM `administrator`@`%`;

-- Grants for 'afuentes'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE USER, EVENT, TRIGGER, CREATE ROLE, DROP ROLE ON *.* TO `afuentes`@`%` WITH GRANT OPTION;
GRANT APPLICATION_PASSWORD_ADMIN,BACKUP_ADMIN,CONNECTION_ADMIN,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_USER_RESOURCES,ROLE_ADMIN,SHOW_ROUTINE,XA_RECOVER_ADMIN ON *.* TO `afuentes`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `afuentes`@`%`;
REVOKE INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE VIEW, EVENT, TRIGGER ON `mysql`.* FROM `afuentes`@`%`;
REVOKE CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE VIEW, EVENT, TRIGGER ON `mysql_audit`.* FROM `afuentes`@`%`;
REVOKE CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE VIEW, EVENT, TRIGGER ON `sys`.* FROM `afuentes`@`%`;

-- Grants for 'ai_svc'@'%'
GRANT USAGE ON *.* TO `ai_svc`@`%`;
GRANT SELECT ON `byzfunder_Jovan`.* TO `ai_svc`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `ai_svc`@`%`;

-- Grants for 'akyureghya'@'%'
GRANT USAGE ON *.* TO `akyureghya`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `akyureghya`@`%`;

-- Grants for 'backupadmin'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON *.* TO `backupadmin`@`%` WITH GRANT OPTION;
REVOKE INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `mysql`.* FROM `backupadmin`@`%`;
REVOKE CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `mysql_audit`.* FROM `backupadmin`@`%`;
REVOKE CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `sys`.* FROM `backupadmin`@`%`;

-- Grants for 'bkadmin'@'%'
GRANT USAGE ON *.* TO `bkadmin`@`%`;

-- Grants for 'bswadling'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, PROCESS, REFERENCES, INDEX, ALTER, CREATE VIEW, SHOW VIEW, TRIGGER ON *.* TO `bswadling`@`%` WITH GRANT OPTION;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON `byzfunder_mca1`.* TO `bswadling`@`%` WITH GRANT OPTION;
REVOKE INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE VIEW, TRIGGER ON `mysql`.* FROM `bswadling`@`%`;
REVOKE CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE VIEW, TRIGGER ON `mysql_audit`.* FROM `bswadling`@`%`;
REVOKE CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE VIEW, TRIGGER ON `sys`.* FROM `bswadling`@`%`;

-- Grants for 'byzfunder1'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE ROLE, DROP ROLE ON *.* TO `byzfunder1`@`%` WITH GRANT OPTION;
GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ADMIN,BACKUP_ADMIN,CONNECTION_ADMIN,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,REPLICATION_APPLIER,ROLE_ADMIN,SHOW_ROUTINE,XA_RECOVER_ADMIN ON *.* TO `byzfunder1`@`%` WITH GRANT OPTION;
GRANT CREATE TEMPORARY TABLES ON `sys`.* TO `byzfunder1`@`%` WITH GRANT OPTION;
GRANT SELECT, INSERT, UPDATE, DELETE, DROP, TRIGGER ON `byzfunder_portal2D`.* TO `byzfunder1`@`%`;
REVOKE INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `mysql`.* FROM `byzfunder1`@`%`;
REVOKE CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `mysql_audit`.* FROM `byzfunder1`@`%`;
REVOKE CREATE, DROP, REFERENCES, INDEX, ALTER, LOCK TABLES, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `sys`.* FROM `byzfunder1`@`%`;
GRANT PROXY ON ``@`` TO `byzfunder1`@`%` WITH GRANT OPTION;
GRANT `administrator`@`%` TO `byzfunder1`@`%` WITH ADMIN OPTION;

-- Grants for 'byzfunder_app'@'%'
GRANT USAGE ON *.* TO `byzfunder_app`@`%`;
GRANT ALL PRIVILEGES ON `byzfunder_mca1`.* TO `byzfunder_app`@`%`;

-- Grants for 'byzfunder_dev_readonly'@'%'
GRANT SELECT, PROCESS ON *.* TO `byzfunder_dev_readonly`@`%`;
GRANT SELECT, SHOW VIEW ON `byzfunder_mca1`.* TO `byzfunder_dev_readonly`@`%`;

-- Grants for 'bzfunder_Replicate'@'%'
GRANT SELECT, INSERT, UPDATE, CREATE, REPLICATION SLAVE ON *.* TO `bzfunder_Replicate`@`%`;
REVOKE INSERT, UPDATE, CREATE ON `mysql`.* FROM `bzfunder_Replicate`@`%`;
REVOKE CREATE ON `mysql_audit`.* FROM `bzfunder_Replicate`@`%`;
REVOKE CREATE ON `sys`.* FROM `bzfunder_Replicate`@`%`;

-- Grants for 'cmaity'@'%'
GRANT USAGE ON *.* TO `cmaity`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `cmaity`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `cmaity`@`%`;

-- Grants for 'cshah'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE ROLE, DROP ROLE ON *.* TO `cshah`@`%` WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON `byzfunder_mca1`.* TO `cshah`@`%`;
REVOKE INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `mysql`.* FROM `cshah`@`%`;
REVOKE CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `mysql_audit`.* FROM `cshah`@`%`;
REVOKE CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `sys`.* FROM `cshah`@`%`;

-- Grants for 'daslanyan'@'%'
GRANT USAGE ON *.* TO `daslanyan`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `daslanyan`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `daslanyan`@`%`;

-- Grants for 'dev_lendsaas'@'%'
GRANT USAGE ON *.* TO `dev_lendsaas`@`%`;

-- Grants for 'dtserunyan'@'%'
GRANT USAGE ON *.* TO `dtserunyan`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `dtserunyan`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `dtserunyan`@`%`;

-- Grants for 'ebalasanyan'@'%'
GRANT USAGE ON *.* TO `ebalasanyan`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `ebalasanyan`@`%`;

-- Grants for 'egershman'@'%'
GRANT USAGE ON *.* TO `egershman`@`%`;

-- Grants for 'eweiner'@'%'
GRANT USAGE ON *.* TO `eweiner`@`%`;
GRANT SELECT ON `DS`.* TO `eweiner`@`%`;
GRANT SELECT ON `byzfunder_Jovan`.* TO `eweiner`@`%`;
GRANT SELECT ON `byzfunder_dev`.* TO `eweiner`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `eweiner`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `eweiner`@`%`;
GRANT SELECT ON `core_data`.* TO `eweiner`@`%`;

-- Grants for 'flow_capture'@'%'
GRANT USAGE ON *.* TO `flow_capture`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `flow_capture`@`%`;

-- Grants for 'ggurumoorthy'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, PROCESS, INDEX, ALTER, REPLICATION CLIENT, CREATE USER, EVENT, CREATE ROLE, DROP ROLE ON *.* TO `ggurumoorthy`@`%` WITH GRANT OPTION;
GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ADMIN,BACKUP_ADMIN,CONNECTION_ADMIN,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,REPLICATION_APPLIER,ROLE_ADMIN,XA_RECOVER_ADMIN ON *.* TO `ggurumoorthy`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `ggurumoorthy`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `ggurumoorthy`@`%`;
REVOKE INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, EVENT ON `mysql`.* FROM `ggurumoorthy`@`%`;
REVOKE CREATE, DROP, INDEX, ALTER, EVENT ON `mysql_audit`.* FROM `ggurumoorthy`@`%`;
REVOKE CREATE, DROP, INDEX, ALTER, EVENT ON `sys`.* FROM `ggurumoorthy`@`%`;

-- Grants for 'hbalasyan'@'%'
GRANT USAGE ON *.* TO `hbalasyan`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `hbalasyan`@`%`;
GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON `byzfunder_portal2D`.* TO `hbalasyan`@`%`;

-- Grants for 'hharutyunyan'@'%'
GRANT USAGE ON *.* TO `hharutyunyan`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `hharutyunyan`@`%`;

-- Grants for 'jcarcione'@'%'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE ROLE, DROP ROLE ON *.* TO `jcarcione`@`%`;
GRANT ALL PRIVILEGES ON `byzfunder_mca1`.* TO `jcarcione`@`%`;
REVOKE INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `mysql`.* FROM `jcarcione`@`%`;
REVOKE CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `mysql_audit`.* FROM `jcarcione`@`%`;
REVOKE CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `sys`.* FROM `jcarcione`@`%`;

-- Grants for 'jchen'@'%'
GRANT USAGE ON *.* TO `jchen`@`%`;
GRANT SELECT ON `DS`.* TO `jchen`@`%`;
GRANT SELECT ON `byzfunder_Jovan`.* TO `jchen`@`%`;
GRANT SELECT ON `byzfunder_dev`.* TO `jchen`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `jchen`@`%`;
GRANT SELECT ON `core_data`.* TO `jchen`@`%`;

-- Grants for 'jfrancois'@'%'
GRANT USAGE ON *.* TO `jfrancois`@`%`;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `DS`.* TO `jfrancois`@`%`;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `byzfunder_Jovan`.* TO `jfrancois`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `jfrancois`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `jfrancois`@`%`;
GRANT SELECT ON `core_data`.* TO `jfrancois`@`%`;

-- Grants for 'jherr'@'%'
GRANT USAGE ON *.* TO `jherr`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `jherr`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `jherr`@`%`;

-- Grants for 'lane_lane'@'%'
GRANT PROCESS ON *.* TO `lane_lane`@`%`;
GRANT CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE ROUTINE, ALTER ROUTINE, EVENT ON `byzfunder_mca1`.* TO `lane_lane`@`%`;

-- Grants for 'lendsaas_dev'@'%'
GRANT USAGE ON *.* TO `lendsaas_dev`@`%`;
GRANT ALL PRIVILEGES ON `byzfunder_portal2D`.* TO `lendsaas_dev`@`%`;

-- Grants for 'magna5'@'%'
GRANT SELECT, UPDATE, DROP, PROCESS, SHOW DATABASES, SHOW VIEW ON *.* TO `magna5`@`%`;
GRANT FLUSH_STATUS ON *.* TO `magna5`@`%`;
REVOKE UPDATE, DROP ON `mysql`.* FROM `magna5`@`%`;
REVOKE DROP ON `mysql_audit`.* FROM `magna5`@`%`;
REVOKE DROP ON `sys`.* FROM `magna5`@`%`;

-- Grants for 'mbarela'@'%'
GRANT PROCESS, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT, CREATE USER, EVENT, CREATE ROLE, DROP ROLE ON *.* TO `mbarela`@`%`;
REVOKE EVENT ON `mysql`.* FROM `mbarela`@`%`;
REVOKE EVENT ON `mysql_audit`.* FROM `mbarela`@`%`;
REVOKE EVENT ON `sys`.* FROM `mbarela`@`%`;

-- Grants for 'mbarseghyan'@'%'
GRANT USAGE ON *.* TO `mbarseghyan`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `mbarseghyan`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `mbarseghyan`@`%`;

-- Grants for 'mterhovhannisyan'@'%'
GRANT USAGE ON *.* TO `mterhovhannisyan`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `mterhovhannisyan`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `mterhovhannisyan`@`%`;

-- Grants for 'nkhachatryan'@'%'
GRANT USAGE ON *.* TO `nkhachatryan`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `nkhachatryan`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `nkhachatryan`@`%`;

-- Grants for 'norbert_norbert'@'%'
GRANT USAGE ON *.* TO `norbert_norbert`@`%`;
GRANT ALL PRIVILEGES ON `byzfunder_mca1`.* TO `norbert_norbert`@`%`;

-- Grants for 'ocirpl'@'%'
GRANT REPLICATION SLAVE ON *.* TO `ocirpl`@`%`;
GRANT CONNECTION_ADMIN,GROUP_REPLICATION_STREAM,SERVICE_CONNECTION_ADMIN,SYSTEM_USER ON *.* TO `ocirpl`@`%`;

-- Grants for 'rafsan'@'%'
GRANT USAGE ON *.* TO `rafsan`@`%`;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, CREATE TEMPORARY TABLES, SHOW VIEW, TRIGGER ON `DS`.* TO `rafsan`@`%`;
GRANT SELECT ON `byzfunder_Jovan`.* TO `rafsan`@`%`;
GRANT SELECT ON `byzfunder_dev`.* TO `rafsan`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `rafsan`@`%`;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `core_data`.* TO `rafsan`@`%`;

-- Grants for 'raven'@'%'
GRANT USAGE ON *.* TO `raven`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `raven`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `raven`@`%`;

-- Grants for 'replprod'@'%'
GRANT REPLICATION SLAVE ON *.* TO `replprod`@`%`;

-- Grants for 'reporter'@'%'
GRANT USAGE ON *.* TO `reporter`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `reporter`@`%`;

-- Grants for 'reporter_it'@'%'
GRANT SELECT ON *.* TO `reporter_it`@`%`;

-- Grants for 'sashta'@'%'
GRANT USAGE ON *.* TO `sashta`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `sashta`@`%`;

-- Grants for 'skarapetyan'@'%'
GRANT USAGE ON *.* TO `skarapetyan`@`%`;

-- Grants for 'stitch_user'@'%'
GRANT USAGE ON *.* TO `stitch_user`@`%`;

-- Grants for 'taktileprod'@'%'
GRANT USAGE ON *.* TO `taktileprod`@`%`;
GRANT SELECT ON `byzfunder_Jovan`.* TO `taktileprod`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `taktileprod`@`%`;
GRANT SELECT ON `byzfunder_portal2D`.* TO `taktileprod`@`%`;

-- Grants for 'talktileprod'@'%'
GRANT SELECT ON *.* TO `talktileprod`@`%`;
GRANT SELECT ON `byzfunder_Jovan`.* TO `talktileprod`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `talktileprod`@`%`;

-- Grants for 'testuser'@'%'
GRANT USAGE ON *.* TO `testuser`@`%`;
GRANT SELECT ON `byzfunder_mca1`.* TO `testuser`@`%`;

-- Grants for 'vkumar'@'%'
GRANT USAGE ON *.* TO `vkumar`@`%`;

-- Grants for 'ociadmin'@'127.0.0.1'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `ociadmin`@`127.0.0.1` WITH GRANT OPTION;
GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMPT,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP_REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,TELEMETRY_LOG_ADMIN,XA_RECOVER_ADMIN ON *.* TO `ociadmin`@`127.0.0.1` WITH GRANT OPTION;
GRANT PROXY ON ``@`` TO `ociadmin`@`127.0.0.1` WITH GRANT OPTION;

-- Grants for 'ocidbm'@'127.0.0.1'
GRANT SELECT, PROCESS, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT, SHOW VIEW ON *.* TO `ocidbm`@`127.0.0.1`;
GRANT CONNECTION_ADMIN,SERVICE_CONNECTION_ADMIN,SYSTEM_USER ON *.* TO `ocidbm`@`127.0.0.1`;

-- Grants for 'steph'@'158.62.53.109'
GRANT USAGE ON *.* TO `steph`@`158.62.53.109`;
GRANT SELECT, SHOW VIEW ON `byzfunder_mca1`.* TO `steph`@`158.62.53.109`;

-- Grants for 'mvmvm'@'179.61.199.4'
GRANT SELECT ON *.* TO `mvmvm`@`179.61.199.4`;
GRANT SELECT ON `byzfunder_mca1`.* TO `mvmvm`@`179.61.199.4`;

-- Grants for 'lendsaas_dev'@'192.9.135.71'
GRANT USAGE ON *.* TO `lendsaas_dev`@`192.9.135.71`;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON `byzfunder_portal2D`.* TO `lendsaas_dev`@`192.9.135.71` WITH GRANT OPTION;

-- Grants for 'steph_readonly'@'222.127.188.179'
GRANT USAGE ON *.* TO `steph_readonly`@`222.127.188.179`;
GRANT SELECT ON `byzfunder_mca1`.* TO `steph_readonly`@`222.127.188.179`;

-- Grants for 'api_server_readonly'@'52.53.203.146'
GRANT USAGE ON *.* TO `api_server_readonly`@`52.53.203.146`;
GRANT SELECT ON `byzfunder_mca1`.* TO `api_server_readonly`@`52.53.203.146`;

-- Grants for 'lane_readonly'@'73.184.157.24'
GRANT USAGE ON *.* TO `lane_readonly`@`73.184.157.24`;

-- Grants for 'mvmvm'@'99.177.205.88'
GRANT USAGE ON *.* TO `mvmvm`@`99.177.205.88`;
GRANT SELECT ON `byzfunder_mca1`.* TO `mvmvm`@`99.177.205.88`;

-- Grants for 'newrelic'@'::1'
GRANT SELECT, REPLICATION CLIENT ON *.* TO `newrelic`@`::1`;

-- Grants for 'newrelic'@'localhost'
GRANT SELECT, REPLICATION CLIENT ON *.* TO `newrelic`@`localhost`;

-- Grants for 'oracle-cloud-agent'@'localhost'
GRANT SELECT, PROCESS, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT, SHOW VIEW ON *.* TO `oracle-cloud-agent`@`localhost`;
GRANT CONNECTION_ADMIN,SERVICE_CONNECTION_ADMIN,SYSTEM_USER ON *.* TO `oracle-cloud-agent`@`localhost`;

-- Grants for 'root'@'localhost'
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE ROLE, DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT OPTION;
REVOKE INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `mysql`.* FROM `root`@`localhost`;
REVOKE CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `mysql_audit`.* FROM `root`@`localhost`;
REVOKE CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, CREATE VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON `sys`.* FROM `root`@`localhost`;
GRANT PROXY ON ``@`` TO `root`@`localhost` WITH GRANT OPTION;

-- Grants for 'rrhhuser'@'localhost'
GRANT USAGE ON *.* TO `rrhhuser`@`localhost`;
GRANT CONNECTION_ADMIN,SYSTEM_USER ON *.* TO `rrhhuser`@`localhost`;
GRANT SELECT ON `performance_schema`.`threads` TO `rrhhuser`@`localhost`;

