Page 1 of 1

MariaDB - AddUser

Posted: Tue Feb 11, 2020 1:47 pm
by MarioG
Buenos dias
Con TDolphin tengo esta función :AddUser( "%", AllTrim(cUser), AllTrim(cPswUser), shIni["MARIADB"]["database"],, "CREATE,INSERT,UPDATE,DELETE,SELECT,CREATE VIEW,SHOW VIEW" )

Cual es su equivalente con FWNativo

gracias

Re: MariaDB - AddUser

Posted: Tue Feb 11, 2020 10:23 pm
by FranciscoA
Hola Mario.
En MySql lo hago asi:

Code: Select all

oServer:Query("CREATE USER 'Roberto'@'localhost' IDENTIFIED BY 'rober'")
oServer:Query("GRANT ALL PRIVILEGES ON * . * TO 'Roberto'@'localhost'")
oServer:Query("FLUSH PRIVILEGES")
 

Re: MariaDB - AddUser

Posted: Wed Feb 12, 2020 10:41 am
by MarioG
Buenos dias Francisco
Muchisimas gracias!