MariaDB How add a user from FW

[D.Fernandez]

Hi,
I Need add a user from FW with read, write permission.

Thank you, very much

Regards Dario Fernandez

[nageswaragunupudi]

cSql := "CREATE USER 'name'@'location' IDENTIFIED BY 'password'
oCn:Execute( cSql )
// location can be 'localhost' or a wildcard ip address or '%'. '%' indicates from all locations.

cSql := "GRANT ALL PREVILEGES ON 'dataasename.*' TO 'username'@'location'
oCn:Execute( cSql )

ON *.* indicates on all databases
@'%' indicates from all locations.

[D.Fernandez]

Thank you, very much Mr. Rao.

I want DATA privileges ONLY. Select , Insert , Update , Delete , File

Could you show me haw to do it?

Tank you very much

Regards
Dario Fernandez

[nageswaragunupudi]

GRANT SELECT, INSERT, DELETE ON 'database' TO 'username'@'location' IDENTIFIED BY 'password'

[D.Fernandez]

Thank you very much Rao.

Best regards
Ruben Dario Fernandez