Home » SQL & PL/SQL » SQL & PL/SQL » User_jobs (Oracle 10g Windows xp)
User_jobs [message #331640] Fri, 04 July 2008 05:18 Go to next message
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 Go to previous messageGo to next message
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.
Re: User_jobs [message #331643 is a reply to message #331640] Fri, 04 July 2008 05:42 Go to previous messageGo to next message
ShridharV
Messages: 29
Registered: January 2008
Junior Member
Hi

Thanks for the reply. Does Schema2 need any privilege to see the jobs owned by Schema1?
Re: User_jobs [message #331651 is a reply to message #331643] Fri, 04 July 2008 06:15 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
It needs to be able to select on dba_jobs.

Regards
Michel
Previous Topic: need help in creating a view in 10g
Next Topic: Join
Goto Forum:
  


Current Time: Sat Feb 08 07:53:23 CST 2025