quick SQL query - GRANT

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
sh33p1985
Forum Commoner
Posts: 78
Joined: Thu Mar 11, 2004 9:22 am

quick SQL query - GRANT

Post 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
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: quick SQL query - GRANT

Post 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;
(#10850)
Post Reply