Oracle grant for scripting of tables and views
Posted on 2012-03-29
I am accessing an Oracle database (not sure what version) via Toad for Data Analysts to analyze an existing database. I need to be able to create scripts of existing tables and views. I do not need to run the scripts, create tables, etc.
Toad gives me the following messages when I attempt to create a script:
The requested database object information has not been retrieved.
Object information is retrieved by SYS.DBMS_METADATA.
Check to see that you have privileges for this package.;