Posted on 2011-03-20
Last Modified: 2012-05-11
SQL> alter system set audit_trail=DB scope=spfile;

Can you please tell me DB is the name of the database to provide..
please want to make sure.

Thanks in advance
Question by:nobleit
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Expert Comment

ID: 35176988
No, "DB" is the actual value you specify as in set auditing for the entire database. It is not the name of the database.
LVL 74

Expert Comment

ID: 35177073
DB means your audit records are written to sys.aud$ and are visible through the dba_audit_trail view

Author Comment

ID: 35177753
Can you give me an example?
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 74

Accepted Solution

sdstuber earned 500 total points
ID: 35178127
as a privileged user...

audit alter user

then restart your database, because scope=spfile means the change is only written to the spfile so you must restart to pick it up

then change your password and look in dba_audit_trail  view  you will see a record showing you used the "alter user" command

Author Comment

ID: 35195544
Could you please help me to access dba_audit_trial view..

LVL 74

Expert Comment

ID: 35224620
if you don't have access, you'll have to ask your dba to give you the privilege

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question