September 20, 2011 at 3:52 pm
What are the common ways to setup permissions on Analysis databases?
I know I can create a role that has administrator, process, datareaddefinition,
Any examples how to set some roles in database?
Thanks
September 20, 2011 at 3:58 pm
for most of the time roles are the perfect way to go as you can set permissions down to the dimension member level.
setting them up is fairly straight forward, you just need to right-click on roles in either BIDS or SSMS, and then select create new role and go through the tabs specifying which accounts are in the role and what level of access the role has.
if you require further granularity in your permissions then you can have a look at setting up dynamic cube security
September 20, 2011 at 4:56 pm
I did the exactly the same, I created a processor role and check the process database and read definition. and add this developer account as a member.
But when a developer tried to deploy a cube to the database, h got an error:
- the database ...contains an ImpersonationMode that is reserved for Server Administrators.
whe he tried to deploy as a new DB, he got user doesn't have permission to create a new object in the server.
What could be wrong?
September 20, 2011 at 5:16 pm
when creating a new database they may need a server roles as well
September 20, 2011 at 5:18 pm
Now the database is already there. He just wants to deploy cube, and he got that message.
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply