Hi people,

It's for a web app. My provider provides me only one user profil in the User table. I suppose it's the super-user profil. In order to permit a client to access the database with the right of select, update, insert and delete for the front office (the real web site) and in order to food the database, modify a state for a command... for each person who works in the society (back office), I create two tables: PROFIL + UTILISATEUR (user).

In the UTILISATEUR tables I intend to create a user 'Visitor', password: Visitor, a user Administrator with all privileges, a user operator with the privilege only on the ARTICLE products...

But I don't see the way to assign the rights. I know the command: "GRANT SELECT, INSERT, UPDATE, DELETE ON DB_Install.CLIENT TO Visitor@localhost IDENTIFIED BY password"

This instruction is entered from mysql client, but how must I grant a specific profil inner the code ? I repete that I dispose just one user profil into my provider. I maybe don't understand the way a database is built.

If someone can oriente me, it will be great. Thanx all hot, Ismaël (hope was clear)