Databases Reference
In-Depth Information
The model can be changed. After making changes to the model build, process, and
deploy. This process can be repeated till you are comfortable with the results that
you are looking for. The model can be built with many tables or even a single table.
Tabular model permissions
Permissions are role-based. Permissions for model are created in tabular model roles.
Roles for model projects are defined using Role Manager dialogue in SSDT. When
a model is deployed, roles are managed by database administrators in SQL Server
Management Studio. The following are the roles that are available:
Administrator : Can make changes to schema and query data
Process : Only process operations
Read and Process : Query data and process operations but cannot make
changes to model schema
Read : can query data but cannot make changes to model schema
None : not permitted to make changes to model schema and cannot query
data hands-on
Hands-on exercise 6.3 - creating a role in
SQL Server Data Tools
You define a role in SSDT as described here:
1.
Click on Model to display the drop-down menu.
2.
Click on Roles... .
The Role Manager window appears displaying a top and a bottom pane.
In the top pane, you click the New button and create a role and in the
bottom pane add members to that role.
3.
Click on New .
 
Search WWH ::




Custom Search