CA Service Management

Expand all | Collapse all

How to automatically set User Authorization Level?

Jump to Best Answer
  • 1.  How to automatically set User Authorization Level?

    Posted 01-03-2018 09:45 AM

    Hi! I need to use each user authorization level field so i would like to found a way to set the information automatically. We have 7000 users so manually is not an option...

     

    I already have an external table where I have the user id and the authorization level i want to use. How can I set that number into Catalog's authorization level field? 

     

    Regards



  • 2.  Re: How to automatically set User Authorization Level?
    Best Answer

    Posted 01-03-2018 10:10 AM

    Good Afternoon Sebastian.

    The table to be selected from is:
    SELECT domain,user_id,authorization_level FROM usm_contact_domain

     

    And the update to be executed looks then like this:
    update usm_contact_domain set authorization_level = 20 where user_id = 'xxxxx'

    Kind regards, Louis van Amelsfort.



  • 3.  Re: How to automatically set User Authorization Level?

    Posted 01-03-2018 10:12 AM

    Good Afternoon Sebastian.

    please note: An update on the mdb database direclty is not something we recommend (in general).
    Please be sure, nobody is accessing the mdb at the time you execute the update queries.
    And make a proper backup upfront, to restore to when needed.

    Kind regards, Louis.