Oracle Audit

What is the different between
AUDIT SESSION
and
AUDIT CREATE SESSION
?

I have got no idea what do they audit no matter by success or by failure

anyone can explain, thanks!
mawinghoAsked:
Who is Participating?
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Can I assume you have looked these options up in the Auditing section of the online docs for the version of Oracle you are using?

Most of what you will likely get is copy/paste info on these parameters from the docs or other Internet links.

Is there anything in the docs for these that you find confusing?
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
Now that I'm off mobile and can look things up, I'm unable to come up with anything specific to those audit terms.  

Where did you come across them?
0
 
mawinghoAuthor Commented:
I can execute both statements below successfully.
AUDIT SESSION BY SESSION;
AUDIT CREATE SESSION BY SESSION;

What is AUDIT SESSION in fact? is it auditing someone who try to connect to the database?
if yes, then how the AUDIT CREATE SESSION different from the first one?

thanks!
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
What is your Oracle version.  I will try to find you the documentation link for your version.
0
 
mawinghoAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.