Topic
7 replies Latest Post - ‏2013-01-03T18:27:53Z by SystemAdmin
SystemAdmin
SystemAdmin
5842 Posts
ACCEPTED ANSWER

Pinned topic How to prevent users from creating public queries?

‏2012-12-28T21:21:37Z |
Hi all,

I've been beating my head against this for a while now. We have a lot of users that like to create public queries in SRM and now it's clogging up our lists. Is there a sig option or another simple solution to preventing all users (other than members of MaxAdmin) from being able to create public queries?

We are running 7.2.1 SRM.
Updated on 2013-01-03T18:27:53Z at 2013-01-03T18:27:53Z by SystemAdmin
  • Sreedhar123
    Sreedhar123
    7 Posts
    ACCEPTED ANSWER

    Re: How to prevent users from creating public queries?

    ‏2012-12-31T06:37:00Z  in response to SystemAdmin
    By using global data restriction, we can implement your requirement.
  • Sreedhar123
    Sreedhar123
    7 Posts
    ACCEPTED ANSWER

    Re: How to prevent users from creating public queries?

    ‏2012-12-31T06:37:00Z  in response to SystemAdmin
    By using global data restriction, we can implement your requirement.
    • SystemAdmin
      SystemAdmin
      5842 Posts
      ACCEPTED ANSWER

      Re: How to prevent users from creating public queries?

      ‏2013-01-02T16:32:28Z  in response to Sreedhar123
      I tried making the following data restriction but it doesn't appear to be working:

      Attribute Restriction -
      Object - Query
      Attribute - ISPUBLIC
      Application - SR
      Type - READONLY
      Reevalute? - True
      Conditional expression - 1=1
      • P.Heath
        P.Heath
        197 Posts
        ACCEPTED ANSWER

        Re: How to prevent users from creating public queries?

        ‏2013-01-02T21:20:28Z  in response to SystemAdmin
        Try this Conditional expression:

        exists (select 1 from maximo.groupuser where ((upper(groupname) like '%MAXADMIN%')) and (userid = :&USERNAME&))

        Best regards,
        Paul Heath Armengol

        Methodology Consultant & Maximo/Rational Tools Administrator
        COSTAISA S.A.
        Barcelona, Spain
        • SystemAdmin
          SystemAdmin
          5842 Posts
          ACCEPTED ANSWER

          Re: How to prevent users from creating public queries?

          ‏2013-01-03T15:15:26Z  in response to P.Heath
          Thanks Paul, however that doesn't appear to work. I should be applying that to the data restriction?
          • P.Heath
            P.Heath
            197 Posts
            ACCEPTED ANSWER

            Re: How to prevent users from creating public queries?

            ‏2013-01-03T15:37:21Z  in response to SystemAdmin
            It works for me, as an Attribute Restriction in global data restrictions.

            The only difference is that I left the Application field empty, so it works for all of them and not just SRs.

            TSRM 7.2.1.x
            DB2 9.x

            Best regards,
            Paul Heath Armengol

            Methodology Consultant & Maximo/Rational Tools Administrator
            COSTAISA S.A.
            Barcelona, Spain
            • SystemAdmin
              SystemAdmin
              5842 Posts
              ACCEPTED ANSWER

              Re: How to prevent users from creating public queries?

              ‏2013-01-03T18:27:53Z  in response to P.Heath
              Thank you Paul. I made a few changes as seen below and now it's working as intended.

              exists (select 1 from maximo.groupuser where ((upper(groupname) in ('group1','group2'))) and (userid = :USER))