I'm working on a project that requires a database user to have only SELECT
and INSERT
permissions for all tables in a database.
The following question provides a solution but I'd have to run the script every time I add a new table. Seems like it's specific to SQL Server 2000.
There must be an easier way?