Versions Compared

Old Version 14

changes.mady.by.user jtel Support

Saved on

compared with

New Version Current

changes.mady.by.user jtel Support

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Removed translated content for 'fr'
Sv translation
languageen

The following commands create a database user "customer" for read access and execute access. These commands should be executed on the master database, or one of them in the case of replication.

From Release 3.33 onwards

From Release 3.33, the JTELCustomer database is used for all customer routines. Customers are only granted read access to the JTELWeb, JTELStats, JTELStats2 and JTELLog databases, and full access to JTELCustomer:

Translations Ignore


Code Block
# Create the user
CREATE USER 'customer'@'%' IDENTIFIED WITH mysql_native_password BY 'secret<secret>';
GRANT SELECT, CREATE TEMPORARY TABLES, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON JTELWeb
# Grant the user access to read everything and execute all stored procedures on all DBs
GRANT SELECT ON *.* TO 'customer'@'%';
GRANT SELECT, CREATE TEMPORARY TABLES, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON JTELStats*.* TO 'customer'@'%';
GRANT SELECT, CREATE TEMPORARY TABLES, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON JTELStats2 ON *.* TO 'customer'@'%';
GRANT SHOW VIEW ON *.* TO 'customer'@'%';
GRANT
# SELECT,Grant CREATEthe TEMPORARYuser TABLES,full CREATEaccess ROUTINE,to ALTER ROUTINE, EXECUTEcustomer db
GRANT ALL ON JTELLogJTELCustomer.* TO 'customer'@'%';

# Make changes active
FLUSH PRIVILEGES;

We recommend that the customer access the slave database for most purposes.

Sv translation
languagede

Status
colourRed
titleThis page is only available in English


Before Release 3.33

Before release 3.33, the JTELCustomer database was not present, necessitating CREATE / ALTER ROUTINE access to the JTEL databases:

Sv translation
languagefr

Les commandes suivantes permettent de créer un "client" utilisateur de la base de données pour l'accès en lecture et l'accès en exécution. Ces commandes doivent être exécutées sur la base de données principale, ou sur l'une d'entre elles en cas de réplication.

Translations Ignore


Code Block
CREATE USER 'customer'@'%' IDENTIFIED WITH mysql_native_password BY 'secret'; 
GRANT SELECT, CREATE TEMPORARY TABLES, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON JTELWeb.* TO 'customer'@'%'; 
GRANT SELECT, CREATE TEMPORARY TABLES, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON JTELStats.* TO 'customer'@'%'; 
GRANT SELECT, CREATE TEMPORARY TABLES, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON JTELStats2.* TO 'customer'@'%'; 
GRANT SELECT, CREATE TEMPORARY TABLES, CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON JTELLog.* TO 'customer'@'%'; 
FLUSH PRIVILEGES;
Nous recommandons au client d'accéder à la base de données des esclaves pour la plupart de ses besoins.

We recommend that the customer access the slave database for most purposes.
 Sv translation
languagede
 Status
colourRed
titleThis page is only available in English