Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

How to export actual user rights per user?

Avatar

Avatar
Validate 1
Level 2
Suzanne_J_
Level 2

Likes

8 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
Suzanne_J_
Level 2

Likes

8 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
Suzanne_J_
Level 2

19-12-2016

I would like to create a workflow with a query that will give me an overview of the actual user rights per user including exceptions. I can't find a way to pull this data. Can someone help me with this?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
Employee
Linda_Stinson
Employee

Likes

51 likes

Total Posts

250 posts

Correct Reply

77 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 20
Ignite 10
View profile

Avatar
Validate 1
Employee
Linda_Stinson
Employee

Likes

51 likes

Total Posts

250 posts

Correct Reply

77 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 20
Ignite 10
View profile
Linda_Stinson
Employee

20-12-2016

Also you can ask your question on the new Adobe Campaign product discussion forum.

Adobe Campaign

The forum you are in is for questions related to the Online Learning paths available to Adobe partners and employees.

Regards,

Linda

Answers (6)

Answers (6)

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

19-12-2016

Hi Suzanne,

Operator and named rights have a many to many relationship.

An operator can be directly connected to names rights or it will be part of an operator group which is then linked to a named right.

  1. Use a query activity to get all named rights.
  2. Perform a change dimension to obtain Operator Groups. In the change dimension activity select (All records).
  3. Then again perform a change dimension to get operators from xtk:operator schema. Again select all records.
  4. Repeat the above methodology to start from named rights and a direct change dimension to operator (all records).
  5. Perform a Union on output from Step 3 and Step 4.

Hope it helps.

Regards,
Vipul Raghav

Avatar

Avatar
Validate 1
Level 2
Suzanne_J_
Level 2

Likes

8 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
Suzanne_J_
Level 2

Likes

8 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
Suzanne_J_
Level 2

20-12-2016

Hi Vipul,

Thank you for your help so far.

Best regards,

Suzanne

Avatar

Avatar
Validate 1
Level 2
Suzanne_J_
Level 2

Likes

8 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
Suzanne_J_
Level 2

Likes

8 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
Suzanne_J_
Level 2

20-12-2016

Hi Linda,

Thanks for your reply. Yes, I'm aware of the audit tab, but the thing is I have to know this information about 170 users and that's why I was looking for a query to do this.

Best regards,

Suzanne

Avatar

Avatar
Validate 1
Employee
Linda_Stinson
Employee

Likes

51 likes

Total Posts

250 posts

Correct Reply

77 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 20
Ignite 10
View profile

Avatar
Validate 1
Employee
Linda_Stinson
Employee

Likes

51 likes

Total Posts

250 posts

Correct Reply

77 solutions
Top badges earned
Validate 1
Ignite 5
Ignite 3
Ignite 20
Ignite 10
View profile
Linda_Stinson
Employee

20-12-2016

Is your goal to merely view this information?

The Audit tab on the Operator form in the Adobe Campaign Client Console shows all folders that the user has access to and the type of access (R/W/D) to data in the folder. That together with their named rights which control UI elements would be useful. You might want to look at how the client console is retrieving that information.

Linda

Avatar

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
Employee
Vapsy
Employee

Likes

370 likes

Total Posts

726 posts

Correct Reply

342 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Vapsy
Employee

20-12-2016

HI Suzanne,

It will be difficult to actually explain this information. It is an unusual request and normally other make use of campaign console to visualize the named rights and operators associated with it.

Sorry, for not being able to help you completely.

Regards,
Vipul

Avatar

Avatar
Validate 1
Level 2
Suzanne_J_
Level 2

Likes

8 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Validate 1
Level 2
Suzanne_J_
Level 2

Likes

8 likes

Total Posts

17 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
View profile
Suzanne_J_
Level 2

20-12-2016

Hi Vipul,

Thank you for your quick answer! I think I did manage the steps you described, but now I'm struggling to analyse the data / look at the right columns to see the information I need. I'm not sure if you can help me with that. My knowledge about Adobe Campaign is now 8 weeks old so I'm really a beginner and discovering the database structure.

Best regards,

Suzanne