Re: granting select only priviledges
I echo the comments. try:-
OUTPUT TO "revoke.sql"
SELECT "revoke all on ", tabname, " from <user>;"
FROM systables
WHERE tabid > 100;
This will create quite a nice little script which, when executed, will
revoke all from all tables for a particular user.
Sean
Steve Wenzbauer wrote in message <74iett$t6r$1@news-2.news.gte.net>...
>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.
>
>
>