Hello Mike:
Yes, that will work.
But, I really didn't want the user to be part of one of those.
I did find a script at swynk.com for 6.5 that does the trick.
I haven't bothered to find out if it works in 7.0.
It just cycles through all tables and views in the database and grants the rights.
Rick
>>Is there any way to grant permissions on all of the tables in a database at the same time without doing a GRANT ALL for each table, one by one?
>
>I don't think so. What about GRANTING permissions to a role and then making the specific users members of the role. Does one of the fixed database roles server the purpose that you need?
>
>-Mike
Richard DeZeeuw
DeZeeuw Software Inc.