Hi,
You need to look at the GRANT and REVOKE commands in the SQL documentation.
e.g. to allow harold read-only on table contacts command (run by table
owner) would be similar to:
REVOKE all ON contacts FROM harold;
GRANT select ON contacts TO harold;
and to deny a user access to a table just
On this same note, can you restrict a certain user to just read-only and allow
others to have write access to certain tables. If so, how would I go about this?
Thanks
-
/ Gregg Berkholtz - Owner/Consultant
|G B|PC, Nov
