Hi @Madhavi Hardas ,
Here is the list of permissions necessary for SSMA to function with the explanation as to why each permission is needed: https://learn.microsoft.com/en-us/sql/ssma/oracle/connecting-to-oracle-database-oracletosql?view=sql-server-ver15
Unfortunately it is not up to us to decide which permission controls access to what data in Oracle. CREATE ANY PROCEDURE
, for instance, is needed to access the PL/SQL text associated with the procedure. There is simply no READ ANY PROCEDURE
permission.
In order to better understand what particular system data dictionary/view is hidden behind what permission in Oracle, you can switch "Collector" logs to "Debug" under Tools -> Global Settings -> Logging in SSMA. Once you attempt to connect to Oracle with the "read-only access" user, you will be able to see in the log file which queries SSMA attempted to execute and whether they have failed due to permissions.
Regards,
Alex.