I have a user connecting to Teradata 14.00.03.07 via SAS 9.2. The user has been granted multiple Teradata roles (with a default role) but would like the ability to switch roles within SAS. I read something about using QUERY_BAND to set a proxy role but it didn't seem to apply in this case.
I'd like to avoid setting the user's default role to "ALL". Is this at all possible? If so does anyone have the correct syntax?
Any help would be greatly appreciated.