Home » SQL & PL/SQL » SQL & PL/SQL » JOB's grant
JOB's grant [message #271981] Wed, 03 October 2007 09:58 Go to next message
tomk
Messages: 17
Registered: March 2006
Junior Member
Hi all,

How can i check grants, that were given to users on jobs?
I did
grant alter on job_name to user1


And now I want to check to which user the grant on "job_name" was given...

Thanks in advance.
Re: JOB's grant [message #271982 is a reply to message #271981] Wed, 03 October 2007 10:09 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
Is the SEARCH button broken for you?


SELECT VIEW_NAME FROM DBA_VIEWS WHERE VIEW_NAME LIKE '%PRIV%'

Do any of the results from above appear to be likely candidates which might answer your question?

[Updated on: Wed, 03 October 2007 10:11] by Moderator

Report message to a moderator

Re: JOB's grant [message #271983 is a reply to message #271981] Wed, 03 October 2007 10:11 Go to previous message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide and its section about Oracle documentation.
Please always post your Oracle version (4 decimals).

Regards
Michel
Previous Topic: explanation
Next Topic: Tunned querry
Goto Forum:
  


Current Time: Wed Dec 07 05:15:06 CST 2016

Total time taken to generate the page: 0.09002 seconds