<div>
Recommendation to close this question by accepting the above comments as solution.
</div>


Recommendation to close this question by accepting the above comments as solution.

<div>
<div class="content wysiwyg-content">
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. &nbsp; 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.<br />
<br />
I am reading about 2012 Server Roles and am not figuring out how to do this.
</div>
</div>


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.

sql server/database roles.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.