User_jobs [message #331640] |
Fri, 04 July 2008 05:18  |
ShridharV
Messages: 29 Registered: January 2008
|
Junior Member |
|
|
Hi,
Suppose there are 2 schemas Schema1 and Schema2.
Is it possible for Schema2 to access User_jobs of Schema1?
|
|
|
Re: User_jobs [message #331641 is a reply to message #331640] |
Fri, 04 July 2008 05:32   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
No. USER_ views just show the details for the user you are logged in as.
Schema2 can look at ALL_JOBS WHERE owner = 'Schema1', which will achieve much the same effect.
|
|
|
|
|