We have a setup on a SQL 2012 server in which there are views and stored procedures on one database that pull from tables on another database (same server). So as far as I can figure out when we need a login to have access to the view we also need to grant rights on the 'tables' database as well. So we have add permissions to one of the databases and then to the other database each time we have a new user that needs access. If there is no way around this, I would like to create something like a role which is set up with the permissions to the two databases, and then we just add users to the role.
I am reading about 2012 Server Roles and am not figuring out how to do this.