Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | DB - RedShift |
| Version | 15.0 |
|
|
53 KB
|
|
34 KB
Your test scenario is incorrect. I tested the same and I got the correct result. See attached screenshot.
To test this correctly - create a new user for e.g tariq. Create a new Server Connection with the login named tariq and give access to the Database and Schema which you are testing
Now in your original server connection, first enable the permission to tariq to the view.
Now login with tariq user and perform a Select and you can see Select query works.
Now in original server connection, revoke permission on view to tariq
In your tariq server connection, try to execute the same query and you get
Issue #12080 |
| Closed |
| Invalid |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
Your test scenario is incorrect. I tested the same and I got the correct result. See attached screenshot.
To test this correctly - create a new user for e.g tariq. Create a new Server Connection with the login named tariq and give access to the Database and Schema which you are testing
Now in your original server connection, first enable the permission to tariq to the view.
Now login with tariq user and perform a Select and you can see Select query works.
Now in original server connection, revoke permission on view to tariq
In your tariq server connection, try to execute the same query and you get