No question at this time
DBA Top 10
1 A. Kavsek 10000
2 M. Cadot 9900
3 B. Vroman 5700
4 P. Wisse 4300
5 J. PĂ©ran 1800
6 . Lauri 1200
7 J. Schnackenberg 600
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48503
Total active users1429
Act. users last 24h2
Act. users last hour0
Registered user hits last week104
Registered user hits last month599
Go up

Monitor user access
Next thread: failed to create file system01.dbf
Prev thread: SQL Script

Message Score Author Date
Hi, I need SQL statements to monitor 'P10' use...... Balaji M Jul 02, 2011, 19:56
What is P10? If you want to monitor user access, ...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Yasir Hashmi Jul 03, 2011, 09:35
Hello, as stated above you can you use auditing...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Matej Pagac Jul 03, 2011, 11:23
HI As now you know auditing is required the foll...... shafique ur rehman Jul 03, 2011, 17:53
Thank you shafique,Matej,yasir for your explanatio...... Balaji M Jul 03, 2011, 20:40

Follow up by mail Click here


Subject: Monitor user access
Author: Balaji M, India
Date: Jul 02, 2011, 19:56, 3253 days ago
Os info: Unix
Oracle info: Oracle 11.1.0.7.0
Message: Hi,

I need SQL statements to monitor 'P10' user access in oracle database.Can somebody
tell me how to monitor user access ?


Thanks
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Monitor user access
Author: Yasir Hashmi, India
Date: Jul 03, 2011, 09:35, 3252 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: What is P10?
If you want to monitor user access, you can enable auditing.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Monitor user access
Author: Matej Pagac, Slovakia
Date: Jul 03, 2011, 11:23, 3252 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: Hello,

as stated above you can you use auditing, or other option is to create trigger (AFTER LOGON ON DATABASE) and monitor all or specific user connection activity. FIrst you create table to store information you wanted and next you create trigger.

For more details please read below:

http://www.dba-oracle.com/art_builder_sec_audit.htm
http://oraclespin.wordpress.com/2008/06/17/logon-trigger-to-monitor-db/

mTj
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Monitor user access
Author: shafique ur rehman, Pakistan
Date: Jul 03, 2011, 17:53, 3252 days ago
Message: HI
As now you know auditing is required the following link will help you also to enable the auditing

http://www.oraclefaq.net/2007/05/29/how-to-enable-auditing-in-oracle-database/

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Monitor user access
Author: Balaji M, India
Date: Jul 03, 2011, 20:40, 3252 days ago
Message: Thank you shafique,Matej,yasir for your explanation and for the links provided.

--P10 is a user

I verified DBA_AUDIT and it is already enabled in my database.

SQL> show parameter audit

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /usr/local/opt/oracle/product/
bala2/rdbms/audit
audit_sys_operations boolean TRUE
audit_syslog_level string
audit_trail string DB
SQL>

I used following query to find 'P10' user access in database.

SELECT username,
extended_timestamp,
owner,
obj_name,
action_name
FROM dba_audit_trail
WHERE owner = 'P10'
ORDER BY timestamp;

Please correct if the above query is wrong.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here