[Subject Prev][Subject Next][Thread Prev][Thread Next][Subject Index][Thread Index]
I guess there're atleast a couple of other ways of accomplishing this
apart from what you've outlined:
1. Let the script have root access to MySQL. Alternatively, let the
script have full rights through a special user-ID on the table.
2. Let the user have full rights on the table.
There shouldn't be a problem with permissions since all updates will
be done under control of your program.
>>>>> "Amit" == Amit Soni <amitsoni@xxxxxxxxxxxx> writes:
Amit> Ok, we'll see about the fight in the meet. for now..help me
Amit> ! ;o)
Amit> I wanna setup a very simple database of user infomation
Amit> name,address, email etc in mysql.
Amit> Now The passwords for this db i wanna store in mysql(lemme
Amit> know of a better way)
Amit> Now once the user has created an account. suppose he wants
Amit> to change some info.
Amit> Now since Mysql does not permit.row based user
Amit> rights.(minimum is table based)
Amit> what i do is.....I create a temp table in the db with his
Amit> session id. give him insert/delete/select etc rights on this
Amit> table. and he can right to this table and then later on the
Amit> content s will be transfered to....the main table.
Amit> Is there a better way of accomplishing this ?
Amit> What i wanna avoid is. To create the temp table i have to
Amit> print the username and password of one user in my cgi
Amit> What i want is that a user in mysql should be such that..
Amit> 1. He can Insert into the userinformation table. 2. He can
Amit> modify the contents of all coloumns in userinfomation table
Amit> where userid=hisuserid.
Amit> I am sure all web programmers here must have done such a
Amit> thing. Since i am a bit weak in databases. please help me.
Raju Mathur raju@xxxxxxxxxxxxx http://kandalaya.org/