Home » SQL & PL/SQL » SQL & PL/SQL » Onlogon Database triggers (oracle 9i or 10g)
Onlogon Database triggers [message #405320] Wed, 27 May 2009 06:30 Go to next message
kensoft
Messages: 3
Registered: March 2009
Junior Member
Can i wrt onlogon database level trigger while user login to databse through SQL.

And Is it possible to fetch mac id or cpu id of a machine using sql command.
Re: Onlogon Database triggers [message #405341 is a reply to message #405320] Wed, 27 May 2009 07:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can i wrt onlogon database level trigger while user login to databse through SQL.

Yes, if you have the privilege to do so.

Quote:
And Is it possible to fetch mac id or cpu id of a machine using sql command.

Not on the server for the client.

Regards
Michel
Re: Onlogon Database triggers [message #405531 is a reply to message #405341] Thu, 28 May 2009 04:59 Go to previous messageGo to next message
kensoft
Messages: 3
Registered: March 2009
Junior Member
Can i wrt onlogon database level trigger while user login to databse through SQL.


If Yes, pls send some example.

And Is it possible to fetch mac id or cpu id of a machine using sql command.


pls send some example for the client.
Re: Onlogon Database triggers [message #405543 is a reply to message #405531] Thu, 28 May 2009 05:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What don't you understand in "it is not possible"?

Regards
Michel
Re: Onlogon Database triggers [message #405553 is a reply to message #405543] Thu, 28 May 2009 06:33 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
Michel Cadot wrote on Thu, 28 May 2009 11:45
What don't you understand in "it is not possible"?

Regards
Michel


Presumably the "not" bit Wink
Re: Onlogon Database triggers [message #405618 is a reply to message #405543] Thu, 28 May 2009 12:28 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Michel Cadot wrote on Thu, 28 May 2009 12:45
What don't you understand in "it is not possible"?

Regards
Michel


Maybe you used too many complete words.
Previous Topic: Sorting alpha numeric data
Next Topic: Finding matching records from another table
Goto Forum:
  


Current Time: Thu Dec 08 18:40:34 CST 2016

Total time taken to generate the page: 0.08195 seconds