Skip to Content
avatar image
Former Member

query to get user list with their rights?

Hi BO exports,

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

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 19, 2012 at 12:58 PM

    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.



    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Yes, both tools are available in XI3.1

      Query builder tool can be found at URL:


      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.