|
Forum: Server Administration
|
|
Topic: Traditional auditing: how to query existing audits?
|
| Re: Traditional auditing: how to query existing audits? [message #689805 is a reply to message #689792] |
Fri, 26 April 2024 07:21 |
 |
Darth Waiter
Messages: 78
Registered: October 2020
|
Member |
|
|
I realized that I also need to determine programmatically whether only the traditional auditing is available, traditional or unified, or unified only.
Which will be a better way of doing it: by looking at whether the above views exist and which combination thereof, or by querying the version (pre-12, post-23)?
|
|
|
|
| Re: Traditional auditing: how to query existing audits? [message #689807 is a reply to message #689805] |
Fri, 26 April 2024 12:37 |
 |
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
SQL> col parameter format a30
SQL> col value format a30
SQL> select * from v$option where lower(parameter) like '%audit%' order by 1;
PARAMETER VALUE CON_ID
------------------------------ ------------------------------ ----------
Fine-grained Auditing TRUE 0
Unified Auditing FALSE 0
|
|
|
|
|
Forum: Security
|
|
Topic: SYS account is locked (merged)
|
| Re: Unlocking Oracle 9i SYS user [message #689806 is a reply to message #266182] |
Fri, 26 April 2024 09:06 |
 |
dom606_user
Messages: 1
Registered: April 2024
|
Junior Member |
|
|
Hi!
Unfortunately, my user "sys" is locked. Maybe you know the solution?
SQL> select account_status from dba_users where username = 'SYS';
ACCOUNT_STATUS
--------------------------------
LOCKED
conn as sysdba
Enter user-name: sys/manager@XE as sysdba
ERROR:
ORA-28000: The account is locked.
BR
|
|
|
|
|
|
Blog
Search
Help
Members
Register
Login
Home
