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

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

    Re: How to prevent users from creating public queries?

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

    Re: How to prevent users from creating public queries?

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

    Re: How to prevent users from creating public queries?

    ‏2013-01-02T16:32:28Z  
    By using global data restriction, we can implement your requirement.
    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
    200 Posts

    Re: How to prevent users from creating public queries?

    ‏2013-01-02T21:20:28Z  
    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
    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

    Re: How to prevent users from creating public queries?

    ‏2013-01-03T15:15:26Z  
    • P.Heath
    • ‏2013-01-02T21:20:28Z
    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
    Thanks Paul, however that doesn't appear to work. I should be applying that to the data restriction?
  • P.Heath
    P.Heath
    200 Posts

    Re: How to prevent users from creating public queries?

    ‏2013-01-03T15:37:21Z  
    Thanks Paul, however that doesn't appear to work. I should be applying that to the data restriction?
    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

    Re: How to prevent users from creating public queries?

    ‏2013-01-03T18:27:53Z  
    • P.Heath
    • ‏2013-01-03T15:37:21Z
    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
    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))