Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17



Posted on 2011-03-20
Medium Priority
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?
Technology Partners: 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 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

715 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