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 | Major |
| Complexity | Unknown |
| Component | App - Schema Browser |
| Version | 15.0 |
Add option to Server Registration->Advanced->[Use X Views] similar to the Oracle [Use DBA_* Views].
| Qs: |
How do you prevent users from displaying objects for which a user has no rights? |
|
|
|
| Probable Cause: | |
 |
The default behavior for both ODBC and .Net is to allow users to see all objects in a database to which they have been given access rights. The purpose of the X Views option is to restrict the view in SQL Assistant to only those objects for which the user has access rights. |
|
|
|
| Solution: | |
|
For a .Net connection, select the Advanced tab and check "Use X Views." |
|
Added the option to the advaced tab. Most tables have an [X] view but some such as DBC.Users, in the case that there is no [X] view we use the normal table. needs lots of testing.
Added the option to the advaced tab. Most tables have an [X] view but some such as DBC.Users, in the case that there is no [X] view we use the normal table. needs lots of testing.
Operations using the X Views are really slow and often takes a lot of time to finish operation. Opening a Query Window takes 10-15 minutes, the Query Builder does not respond. Scripting takes a lot of time and ADS seems like it is hung and I have to kill the process
Operations using the X Views are really slow and often takes a lot of time to finish operation. Opening a Query Window takes 10-15 minutes, the Query Builder does not respond. Scripting takes a lot of time and ADS seems like it is hung and I have to kill the process
The Teradata docs indicate :
>> X views run slower than non-X views because the X views have security checks.
The Teradata docs indicate :
>> X views run slower than non-X views because the X views have security checks.
Verified that all the SQL use X views with the option enabled. The SQL take the same time when executed in a Query Window. The X Views run slower according to the docs and there are many issues logged in the Teradata Forum wrt to slow response with X Views.
Verified in ADS 15.0.0-dev-357
Verified that all the SQL use X views with the option enabled. The SQL take the same time when executed in a Query Window. The X Views run slower according to the docs and there are many issues logged in the Teradata Forum wrt to slow response with X Views.
Verified in ADS 15.0.0-dev-357
Issue #11805 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |