permission on the script and not read.
I plan to learn PERL in the near future, however do not see it being in the
next few month as I've plenty to do. :)
If I've missed something please let me know.
Regards,
Neil Burrows
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