quick SQL query - GRANT
Posted: Mon Jan 22, 2007 12:33 pm
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
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