You can create a lib to be executed in every login?

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Wed, 08 Feb 2006 11:41 pm

I am beginner in Oracle, so bear with me. ...


The question: is it possible to create a lib to be executed in every login?

kind, capturing the login process and perform something.
thecrow
Location: sp - sp

Poston Thu, 09 Feb 2006 8:43 am

You can create a trigger that fires each time the user log in.

Here's an example:
Code: Select all
create table logon_tbl (who varchar2(30), when date);

create or replace trigger trg_logon_db
  after logon on database
begin
  insert into logon_tbl (who, when) values (user, sysdate);
end;
/
is that your question? :-o
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered

Poston Thu, 09 Feb 2006 11:09 pm

almost this ... what I really wanted is whether it is possible to have a lib in c runs as a service of oracle (as soon as I start the oracle, the same I would rise as a \"natural process), and that came in as soon as the user did login. It's more or less what you showed, but that occurs as a \"natural\" service so I can trigger joint actions with other operating system services in oracle is running.

grateful.
thecrow
Location: sp - sp

Poston Fri, 10 Feb 2006 10:59 am

Well, the only way to get something is triggered on each log in oracle is even in this type of trigger.

I believe that you can call your routine in C inside it. But remember that each open session in oracle will fire this trigger.
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered



Return to PL/SQL

Who is online

Users browsing this forum: No registered users and 10 guests