Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 462
  • Last Modified:

spfile

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
0
nobleit
Asked:
nobleit
  • 3
  • 2
1 Solution
 
MrNedCommented:
No, "DB" is the actual value you specify as in set auditing for the entire database. It is not the name of the database.
0
 
sdstuberCommented:
DB means your audit records are written to sys.aud$ and are visible through the dba_audit_trail view
0
 
nobleitAuthor Commented:
Can you give me an example?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
sdstuberCommented:
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
0
 
nobleitAuthor Commented:
Could you please help me to access dba_audit_trial view..

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

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.

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