query to get user list with their rights?

[Former Member]

Hi BO exports,

Is there any way i can get the list of users with thier access rights?

Thanks in advance

[DDortants]

Hello Pavan,

You can use the query builder that comes with BOE and do multiple queries to achieve waht you are looking for.

It is easy to create a select statement in the query builder to get a list of all users.

It be a little harder though and most likely would need a bunhc of queries to get a list of all access rights for a user or users. Mainly because rights are set on certain objects for that user. So you would have to query the various objects (folder, reports, applications, users and groups etc) and retrieve what permissions this user would have on it.

You probably would end up combining it all in an SDK app to do all the complex queries.

We also have the Query results tool in the CMC. But the same applies that it only allows you to create security queries that will give you specific information on a subsection (certain objects) for a user or user group.

Cheers,

Duncan

[Former Member]

we are using BO XI 3.1

do you have any idea how to do that in 3.1?

Thank you in advance

[DDortants]

Yes, both tools are available in XI3.1

Query builder tool can be found at URL:

http://servername:8080/AdminTools

As simple select statement to query for a list of all users is for example:

select si_name from CI_systemobjects where si_kind = 'user'

offcourse you can modify this to get whatever you need.

And the Query results tool also can be found in the CMC of XI3.1.