Creating read and write users in DB
I need to create two users in database: db_reader with read access to all tables and views and dr_writer with Read/write permissions to those objects without possibilities to drop/create/change database objects like tables.
What will be the easies way according to best practices to do that ?