You are correct. However, what I really need is to grant the read permission for all tables except a number of confidential tables. My initial plan was to write a "Grant_Persmission" stored procedure which gets a cursor listing of user tables excluding those confidential tables. Then loop through them and grant the permission accordingly. Unfortunately, I stumble on the looping through the cursor using TSQL.
I am sorry for not specifying my problem clearer in the earlier mail. Any idea how I can solve my problem?
Thanks
>I thought the db_datareader role covers this? Is this what you want?
>
>Explain a little more if ive missed the point.
>
>Jon
>
>
James Chan
ObjectMastery Pty Ltd