question

chana avatar image
chana asked

ssas giving rights . how to give rights in ssas to databases.

how to give rights in ssas to databases.
ssassecuritypermissions
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Cyborg avatar image
Cyborg answered
1. Connect to Analysis Service using Management Studio. 2. Drill down to your database, Go to role -> Create New Role, give a name there. 3. Click Membership from the select page, Click Add button. 4. Click object type button and select users, Choose your Location that can be your active directory, and Add users. 5. You can assign permission against those users or roles against the data sources, cubes, cell data dimensions etc.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.