Toad World® Forums

Missing Priv SELECT on All_USERS

I am reverse engineering from Oracle and get this error. Is there an option I need to specify in Modeler or a permission role I need on the user account?

Hi Rhonda,

isn’t the error message rather “Missing privilege SELECT on system table ALL_USERS”, is it?
That would mean that there is a problem during RE with loading users, permissions and with selecting schemas to load objects from.
To solve this, on the database, set for users privilege SELECT on system table ALL_USERS or some permission role, which would do it as well.
For loading of users, roles and permissions have also SELECT_CATALOG_ROLE role to user assigned.

Regards,
Lukas

Yes, that is the full message. I have been granted permission and have been able to get further. Thank you!

My pleasure, Rhonda.

Regards,
Lukas