Zurück
-
Titel
Schema Compare. Need a list of tables / views being accessed in the background to grant privileges to user. -
Beschreibung
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.
Anmeldung erforderlich
Sie müssen sich anmelden und über einen gültigen Servicevertrag verfügen, um auf Premium-Wissensartikel zugreifen zu zu dürfen.