INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Syncing roles between visual studio an analysis services

Syncing roles between visual studio an analysis services

(OP)
Hello,

is there a possibility to sync the local project in visual studio with the roles on server?

my version: sql server 2008 enterprise

RE: Syncing roles between visual studio an analysis services

Hi rasputin11,

I am not sure but, I do not think so. What happens on your local solution and what happens on the server are two different Cubes. What should happen is that if you make use of Active Directory and the group is created within AD and you always use the same group then that should always be the same cause it is being administred from the same place. I would thus suggest that you make use of a user group on AD. That should solve your problem.

pipe "We know nothing but, that what we know is not the truth..." - Me

RE: Syncing roles between visual studio an analysis services

(OP)
Hi Recce,

Thx for your answer....

I 've written an app, which manages user permissions in a metadata-table-structure.

The permissions will be published via a webservice to the analysis services database (AMO, ADOMD etc).

My problem: If we change something in datawarehouse via visual studio and will publish the changes to AS all roles
will be overridden... with existing roles from visual studio project.

In my opinion there should be an mechanism to prevent this?!



 

RE: Syncing roles between visual studio an analysis services

Hi rasputin11,

I must be honest, this sounds very technical and I am sure there is a lot of detail to this. Don't think I'm the right person to help. Maybe someone else will be able to help if they have done something similiar. Unless you give me a lot mote detail to the process.

pipe "We know nothing but, that what we know is not the truth..." - Me

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close