Setting Session Authorization to Troubleshoot
Sruthi Anumula, Senior Database Support Engineer
September 29, 2023
There are possible scenarios in which a dbadmin would want to run queries as another user to troubleshoot or test. You can use SET SESSION AUTHORIZATION to impersonate another user and run queries. Let's understand this with an example. Here we create a user named test, resource pool named userpool, and make this a default...