Page 1 of 1

quick SQL query - GRANT

Posted: Mon Jan 22, 2007 12:33 pm
by sh33p1985
setup a database with 2 users, admin and guest, connection from the admin connection script works but i get access denied from the guest connetion script - have a feeling its do to with not setting up any access privileges for 'guest'.

can get the first part of the query right but how do i finish it?

GRANT SELECT, INSERT, UPDATE, DELETE ON tbl_x, tbl_y....

thanks

Re: quick SQL query - GRANT

Posted: Mon Jan 22, 2007 3:30 pm
by Christopher
I think it is:

GRANT SELECT, INSERT, UPDATE, DELETE ON tbl_x TO someuser;
GRANT SELECT, INSERT, UPDATE, DELETE ON tbl_y TO someuser;