Loading

How to set privilege in MySql

Naeem Khan

Hello friends ,

I m facing very big in mysql .. i have created data base and i want to set privilege only one table... in my application there are 2 types of user one is Admin and second is general.. now what i want to do general can update record one time next time it will not be update but admin can update many times... spouse general can update marks at one time but Admin can update many times.. hope you understand what i want please help me guys....

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pramod Lawate14y ago
hi naeem u have to maintain usertype colum in your table and one flag it just your confirmation like when u update the record by user first time that time u just update in database user type as user and flag should be true or false and update it but ensure next time user update the the same record that time user type is user and flag is like true then avoid the user

viceversa to administrator
0
14y ago
Is the initial updater doing an insert? Once given a privilege, it can not be intermittently revoked. If you have a PK you will be able to check a table of up-datable content before letting the user update. checkUpdatedOnce(dataset ds) { if(ds.hasrows==true) //Allowupdate callupdate() else MB.show('This row can not be updated again')
0