enabling a user to select from user$
RDBMS Version 19.18.0.0.0 Enterprise Edition
This is on Redhat 8.7
In short : How to enable a user to select from sys.user$?
We are migrating an 11.2 instance to a 19 instance
At the 11.2 instance this user can select from sys.user$
At the 19 instance we can not get the user to select from sys.user$
I tried to "grant select any dictionary"...did not work
I tried "grant dba"... did not work
The good old internet and oracle.support are not to helpfull either.
Cab you point me in the right direction.
Best regards,
Martijn