19c SE2, version 19.20.0.0.0
Just for the sake of understanding if it might be a bug or an issue somewhere else. We have a role. This role has been granted to specific users. Let's say a new privilege, i.e. “grant select…” is added to the role then all users that have this role (default) must be able to query that particular object. Yes, should be the case, however, we have noticed that some users cannot query that object.
Would be interesting to know the reason.
Thanks for any ideas or feedback!