I want to create a role that has only select priviledges. NO sp, vu, insert, delete, etc. priviledges. ONLY select. I know I can do this by explicity selecting "select" within permissions of the role, but I have 95 tables and don't want to be checking all these boxes. Is there a way to give select priviledges to all tables within a database via t-sql. Any help would be cool.
thx