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.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.