Scritp SQL MariaDB and MySQL, Permission

database.sql

/****
 * Script Exemplo para MariaDB ou MySQL com permissões de banco de dados
 *****/

DROP DATABASE IF EXISTS luds;
CREATE DATABASE luds DEFAULT CHARACTER SET utf8 ;

USE luds;
DROP TABLE IF EXISTS arquivos;
CREATE TABLE arquivos( 
      idarquivo  INT  AUTO_INCREMENT    NOT NULL  , 
      nrordem int   NOT NULL  , 
      stAtivo char  (1)   NOT NULL  , 
      img_caminho text   NOT NULL  , 
      dt_inicio datetime   NOT NULL  , 
      dt_fim datetime   NOT NULL  , 
      nmlogin_inclusao varchar  (300)   NOT NULL  , 
      dt_inclusao datetime   NOT NULL  , 
      nmlogin_alteracao varchar  (300)   , 
      dt_alteracao datetime   , 
      dt_exclusao datetime   , 
 PRIMARY KEY (idarquivo)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; 

INSERT INTO `luds`.`arquivos`
(nrordem,`stAtivo`,`img_caminho`,`dt_inicio`,`dt_fim`,`nmlogin_inclusao`,`dt_inclusao`)
VALUES
(1,'S','img/exemplo01.jpg','2022-12-01 10:00:00','2022-12-20 23:59:59','admin',NOW());

INSERT INTO `luds`.`arquivos`
(nrordem,`stAtivo`,`img_caminho`,`dt_inicio`,`dt_fim`,`nmlogin_inclusao`,`dt_inclusao`)
VALUES
(2,'S','img/exemplo02.jpg','2022-12-01 10:00:00','2022-12-20 23:59:59','admin',NOW());

-------- CREATE USER -------------
DROP USER IF EXISTS 'luselect'@'%';
CREATE USER 'luselect'@'%' IDENTIFIED BY '123456';
GRANT SELECT ON luselect.* TO 'luselect'@'%';

INSERT INTO `luds`.`arquivos`
(nrordem,`stAtivo`,`img_caminho`,`dt_inicio`,`dt_fim`,`nmlogin_inclusao`,`dt_inclusao`)
VALUES
(3,'S','img/exemplo03.jpg','2022-12-01 10:00:00','2022-12-20 23:59:59','admin',NOW());

select * from luds.arquivos;

-------- CREATE USER -------------
DROP USER IF EXISTS 'luds'@'%';
CREATE USER 'luds'@'%' IDENTIFIED BY '123456';
GRANT DELETE,EXECUTE,INSERT,SELECT,UPDATE ON luds.* TO 'luds'@'%';

INSERT INTO `luds`.`arquivos`
(nrordem,`stAtivo`,`img_caminho`,`dt_inicio`,`dt_fim`,`nmlogin_inclusao`,`dt_inclusao`)
VALUES
(3,'S','img/exemplo03.jpg','2022-12-01 10:00:00','2022-12-20 23:59:59','admin',NOW());

select * from luds.arquivos;