Re: granting select only priviledges

There is no other way. This can be a bit annoying, but it can be scripted fairly easily. Take the output of a select tabname from systables and format the table names into appropriate revoke and grant statements. >How do I grant select rights for a user to specific tables without having to >name all the tables in the database? I can't believe that anyone would make a >database without allowing you to do so.