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
quick SQL query - GRANT
Moderator: General Moderators
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: quick SQL query - GRANT
I think it is:
GRANT SELECT, INSERT, UPDATE, DELETE ON tbl_x TO someuser;
GRANT SELECT, INSERT, UPDATE, DELETE ON tbl_y TO someuser;
GRANT SELECT, INSERT, UPDATE, DELETE ON tbl_x TO someuser;
GRANT SELECT, INSERT, UPDATE, DELETE ON tbl_y TO someuser;
(#10850)