permissions

Submitted by don_load on Mon, 2010-02-08 18:51 in Price Tapestry

Hi David,
I'm just changing around the database config and wondered about the privileges needed. I've created 3 separate users so querySelect is only allowed to SELECT, queryModify has DELETE, TRUNCATE, INSERT, UPDATE and queryReviews is specific to the reviews table and only allows an INSERT in the reviews table. Apart from the setup file, do you think this covers what the script will be executing?

Regards,

Hi, Yes - that sounds

Submitted by support on Mon, 2010-02-08 18:56

Hi,

Yes - that sounds reasonable!

Cheers,
David.

thanks. It all seems to work

Submitted by don_load on Mon, 2010-02-08 20:53

thanks. It all seems to work ok. Had an odd problem where the admin panel wouldn't work properly and I couldn't accept reviews. Included SELECT in the queryModify permissions and it works now. Can't think why?

regards,
Jay

Hi Jay, Without seeing your

Submitted by support on Mon, 2010-02-08 21:07

Hi Jay,

Without seeing your changes it's hard to say; but don't forget that after moderating the last review, the admin_importReviews() function (from includes/admin.php) is called, which may shed some light...

Cheers,
David.