Schema Compare. where to get a list of tables / views being accessed behind the scenes, so that access or grant can be given to a user.
SELECT_CATALOG_ROLE has been revoked from the user due to restrictions. User is unable to do Schema Compare now. Would like to create views on all the tables/columns used in the background while a user is doing a Schema Compare.
Please provide all the tables/views along with column names when Toad does a Schema Compare. Restrictions does not allow grant to SELECT_CATALOG_ROLE as well as Select * from DBA_% views.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center