Home » RDBMS Server » Security » SQLs to monitor user access (Oracle 11.1.0.7.0,Unix)
SQLs to monitor user access [message #514197] Sat, 02 July 2011 10:41 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi,

There is a user account called 'BALA'.How to create SQLs to monitor 'BALA' user access ?

Thanks

[Updated on: Sat, 02 July 2011 10:43]

Report message to a moderator

Re: SQLs to monitor user access [message #514204 is a reply to message #514197] Sat, 02 July 2011 10:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Define "monitor".

Regards
Michel
Re: SQLs to monitor user access [message #514205 is a reply to message #514204] Sat, 02 July 2011 10:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>There is a user account called 'BALA'.How to create SQLs to monitor 'BALA' user access ?
AUDIT
Re: SQLs to monitor user access [message #514214 is a reply to message #514204] Sat, 02 July 2011 12:09 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Monitor means to watch out what are all the work is being carried in BALA user.


Thanks
Re: SQLs to monitor user access [message #514215 is a reply to message #514205] Sat, 02 July 2011 12:10 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member



Blackswan,

Can you be more elaborate in your answer ?

Thanks
Re: SQLs to monitor user access [message #514216 is a reply to message #514215] Sat, 02 July 2011 12:14 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I am sorry to see that GOOGLE, SEARCH & HELP are broken for you.
Please be patient while repairs are completed.
Additional information will be posted when it becomes available.
Re: SQLs to monitor user access [message #514227 is a reply to message #514215] Sat, 02 July 2011 13:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
balaji14 wrote on Sat, 02 July 2011 19:10


Blackswan,

Can you be more elaborate in your answer ?

Thanks

AUDIT is a SQL statement you will find where we already pointed you.

Regards
Michel

Re: SQLs to monitor user access [message #514231 is a reply to message #514216] Sat, 02 July 2011 13:47 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Thanks Michel..

blackswan,,

I am sorry to say that i cannot wait until GOOGLE, SEARCH & HELP gets repaired.its an urgent task to be completed soon.After knowing those sites are broken only, i posted my questions here.Instead of posting the additional info on those sites after it becomes available, you can directly post the solutions here which will be easy for me.

Smile
Re: SQLs to monitor user access [message #514236 is a reply to message #514231] Sat, 02 July 2011 14:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
But we start to be tired to make your job for you when we already pointed you many times to the basic documentation you even didn't read the TOC till now and way to find information from the dictionary you didn't make the effort to check.

Regards
Michel
Re: SQLs to monitor user access [message #514325 is a reply to message #514197] Mon, 04 July 2011 01:01 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=45037&SkipA=0

Previous Topic: View sysdba tables
Next Topic: To Find A List Of Roles and Privileges In Database
Goto Forum:
  


Current Time: Thu Mar 28 16:44:05 CDT 2024