OraFAQ Forum: Security » SQLs to monitor user access

Home » RDBMS Server » Security » SQLs to monitor user access (Oracle 11.1.0.7.0,Unix)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQLs to monitor user access [message #514197]

Sat, 02 July 2011 10:41

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

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Define "monitor".

Regards
Michel

Report message to a moderator

Re: SQLs to monitor user access [message #514205 is a reply to message #514204]

Sat, 02 July 2011 10:59

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

Report message to a moderator

Re: SQLs to monitor user access [message #514214 is a reply to message #514204]

Sat, 02 July 2011 12:09

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

Report message to a moderator

Re: SQLs to monitor user access [message #514215 is a reply to message #514205]

Sat, 02 July 2011 12:10

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Blackswan,

Can you be more elaborate in your answer ?

Thanks

Report message to a moderator

Re: SQLs to monitor user access [message #514216 is a reply to message #514215]

Sat, 02 July 2011 12:14

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.

Report message to a moderator

Re: SQLs to monitor user access [message #514227 is a reply to message #514215]

Sat, 02 July 2011 13:30

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: SQLs to monitor user access [message #514231 is a reply to message #514216]

Sat, 02 July 2011 13:47

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

Report message to a moderator

Re: SQLs to monitor user access [message #514236 is a reply to message #514231]

Sat, 02 July 2011 14:52

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: SQLs to monitor user access [message #514325 is a reply to message #514197]

Mon, 04 July 2011 01:01

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 04 22:00:27 CST 2025