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?
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.
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.