• Are you saying you want a read only and a read/write role? Separate from db_Datereader/writer?

    That's easy to script.

    loop through all tables in all databases, grant rights to a standard named role (MyReadRole).

    Add users to the role.

    However if you want something that's not a pattern, you have to do it manually.