This issue is also described here:
This might only concern Oracle databases, but possibly others as well.
In SPSS one can import data from a database. One of the first steps is to select the table or view to read from.
This list of tables/views includes public tables/views, ie granted to PUBLIC (any current and future user).
If there are applications installed in the database the list of public tables/view can be large.
A side-note: the query used by SPSS to find all tables/views available to the user varies depending on the odbc-driver used.
When using an Oracle odbc driver it's possible to modify the database for the connecting user so that public tables are excluded. When using the IBM Wire Protocol driver the query is different and cant be "fixed".
As public tables are sometimes (typically?) not interesting for the user, it would be good if there was a setting in SPSS to ignore them when listing available tables.
|Role Summary||End users|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions