Page 11 - Vicente de la Varga Vázquez ACT_01

Apartado b.

CREATE USER 'buyer'@'%' IDENTIFIED BY 'Linkia_FP'
GRANT INSERT ON bbdd_comprascar.compra to 'pedidos'@'%';
GRANT INSERT ON bbdd_comprascar.linea_compra to 'pedidos'@'%'
WITH MAX_CONNECTIONS_PER_HOUR 3;

Apartado c.

CREATE USER 'webmaster'@'%' IDENTIFIED BY 'Linkia_FP'
GRANT SELECT, UPDATE ON bbdd_comprascar.comprador to
'webmaster'@'%';
GRANT SELECT, UPDATE ON bbdd_comprascar.producto to
'webmaster'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE ON bbdd_comprascar.compra
to 'webmaster'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE ON
bbdd_comprascar.linea_compra to 'webmaster'@'%'
WITH MAX_USER_CONNECTIONS 20;

Apartado d.

CREATE USER 'backup'@'%' IDENTIFIED BY 'Linkia_FP'
GRANT SELECT ON bbdd_comprascar.comprador to 'backup'@'%';
GRANT SELECT ON bbdd_comprascar.producto to 'backup'@'%';
GRANT SELECT ON bbdd_comprascar.compra to 'backup'@'%';
GRANT SELECT ON bbdd_comprascar.linea_compra to 'backup'@'%'
WITH MAX_CONNECTIONS_PER_HOUR 3;

Apartado e.

CREATE USER 'visit'@'%' IDENTIFIED BY 'Linkia_FP'
GRANT SELECT ON bbdd_comprascar.v_productos_comprados to
'visit'@'%'
WITH MAX_CONNECTIONS_PER_HOUR 3;

Rellenar las tablas pertinentes.

Ahora vamos rellenar las tablas pertinentes. Y las mostraré en el MySQL Workbech.
Rellenamos la tabla de “compradores”. Utilizaré sólo 3 compradores.

VICENTE DE LA VARGA VÁZQUEZ ASIX 11