Hi,

I have a requirement to give read access to database users. Does anyone have an opinion if it's best practice to create a view for every table and grant the select privilege on them to users, or simply give read only access directly on the tables?

Thank you.

-J

Thanks for the valuable links!

Hi! Thanks for the forums site! We are having an issue with deletes. We need to delete a lot of data from tables once a week. It seems like the more we delete, queries against these tables get slower and slower. Is it better to truncate a table and reload only the data we want? Thank for any help on...