copy and paste this google map to your website or blog!
Press copy button and paste into your blog or website.
(Please switch to 'HTML' mode when posting into your blog. Examples: WordPress Example, Blogger Example)
Rights to view packages (procedures) source code - Ask TOM If you don't want to show the real DBA_SOURCE, you can create a synonym called DBA_SOURCE in that user that points to your filtered view If they do something like ALTER SESSION SET CURRENT_SCHEMA then it could break
How to retrieve the SQL used to create a view in Oracle? In Oracle, to retrieve the SQL used to create a Function, Package, etc, the user_source view can be queried However, views are not included in this view - nor do they exist in the underlying sys source$
Oracle DBA Commonly Used Views - wpollock. com Many of the DBA_ views shown in the table below have corresponding USER_ views that show similar information but for the current user (schema) only Likewise, the various V$ views, which show information about the current instance have matching GV$ views, which show information about all instances
3. 73 ALL_SOURCE - Oracle Help Center DBA_SOURCE describes the text source of all stored objects in the database USER_SOURCE describes the text source of the stored objects owned by the current user This view does not display the OWNER column
Oracle: DBA_SOURCE - René Nyffenegger DBA_SOURCE is a data dictionary view which allows to query the source code of PL SQL objects DBA_SOURCE comes in four variants: USER_SOURCE , ALL_SOURCE , DBA_SOURCE and CDB_SOURCE Select source code of a given PL SQL Package, Procedure or Function, or MLE Module
The PL SQL data dictionary: Make views work for you - Oracle Blogs The USER view: Information about database objects owned by the schema to which you are connected The ALL view: Information about database objects to which the currently connected schema has access The DBA view: Unrestricted information about all the database objects in a database instance
Oracle – Data Dictionary Views – USER vs ALL vs DBA Views - SQL Jana USER_*: Views that start with USER_ list only the objects owned by the currently logged in user ALL_*: Views that start with ALL_ list only the objects the currently logged in user has permissions to access DBA_*: Views that start with DBA_ list all objects unless restricted by the WHERE clause
Using DBA_SOURCE to query package source code - Dev-Notes Below was the quick query I put together, using the DBA_SOURCE view, to hunt down the culprit select name as package_name, line, text from dba_source where owner='MY_SCHEMA' and type='PACKAGE BODY' and ( upper(text) like '%MY_TABLE_NAME%FIELD_NAME%' or upper(text) like '%FIELD_NAME%MY_TABLE_NAME%' ) order by name, line;