Help creating a stored proocedure that give select permissons to all user table in a database?

Thanks
Moueg

Are the number of tables stable or do they vary frequently?

Are the people who require SELECT access fairly stable or do they vary frequently?

Try to select table names from the sysobject system table that has type as "U"

select Name from sysobjects where type = 'u'

For every NAME in the above query run the Grant statement to set appropriate permissions for the user/users that you prefer.

Grant SELECT on TABLE_NAME to USERS_Seperated_by_Comma.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection

The tables do not vary much and users are fairly stable. I'd to give SELECT access to all user tables through a stored procedure.

Thanks!
Moueg

Can you post the code that you have written so far to accomplish this. Let me take a look at it and suggest you to go further on this.

Cheers!

_________________________
- Vijay G
Strive for Perfection