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 +
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)