• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

Oracle and MSSQL LOGGING

Hi,can any one tell me  about oracle logging and mssql logging
0
Cha1tu
Asked:
Cha1tu
  • 5
  • 5
1 Solution
 
slightwv (䄆 Netminder) Commented:
You really should ask these questions separately.

That said: How do you define 'logging'?  That can mean a great many things.
0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Both DBMS have different understanding of how to perform transaction logging (if you mean that). As slightwv told you already, please elaborate more about your question. In particular you should add what you already (think you) know, because proper explanation might get very complex.
0
 
Cha1tuAuthor Commented:
sorry guys ,this is i am some confused about Oracle Logging and Auditing.

i want to Oracle Aduting in 11gR1 databases ,that is in windows 2003 enviornment
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
Cha1tuAuthor Commented:
that is Oracle auditing
0
 
slightwv (䄆 Netminder) Commented:
OK, audit what?  Even the term 'auditing' can mean a few different things.

I would start, as always, in the online docs for your version:
http://www.oracle.com/pls/db111/search?remark=quick_search&word=auditing
0
 
Cha1tuAuthor Commented:
@slightwv:  we have 400 users in our database.i want to enable audting for all users.how can i do that ?can you please tell me that.

i need to enable the auditing DDL's and INSERT,UPDATE,DELETE,LOGIN,LOGOFF  for all the users in the database.

and also i have doubt can i enable auditing with pfile instead of using ALTER SYSTEM SET audit_trail=db SCOPE=SPFILE;

we don't have any spfile in our database.let me know Thanks


0
 
slightwv (䄆 Netminder) Commented:
>>we don't have any spfile in our database

What version of Oracle are you using?

I suggest you spend time in the online docs.  That is the best reference on how to properly set up auditing.

It also talks about purging audit records and some other things you'll need to know.
0
 
Cha1tuAuthor Commented:
11gR1.
0
 
slightwv (䄆 Netminder) Commented:
duh..  you already said that.

You aren't using an SPFILE in 11g?  Are you sure?

0
 
Cha1tuAuthor Commented:
yes,i ask my senior dbas..they said we don't want any spfile..i am also surprized,let me now can i use pfile
0
 
slightwv (䄆 Netminder) Commented:
>>let me now can i use pfile

The audit_trail parameter is just that, a database parameter.  It can be set in the pfile just like any other.
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.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now