Hi,
I Need add a user from FW with read, write permission.
Thank you, very much
Regards Dario Fernandez
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.
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
GRANT SELECT, INSERT, DELETE ON 'database' TO 'username'@'location' IDENTIFIED BY 'password'
Thank you very much Rao.
Best regards
Ruben Dario Fernandez
