Privilege for AFTER LOGON ON DATABASE

[Reshmi Jacob]

Hi

I have created a trigger for identifying the users lgin history :



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;


But the problem is, it is showing INSUFFICEINT PRIVILEGES. Which is the privilege I have to grant this user to excute this trigger.?

Thanks & Regards
Reshmi

[chandu031]

Hi

I have created a trigger for identifying the users lgin history :



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;


But the problem is, it is showing INSUFFICEINT PRIVILEGES. Which is the privilege I have to grant this user to excute this trigger.?

Thanks & Regards
Reshmi

Hi Reshmi,

You have to give the "administer database trigger" privilege for that.
[code=sql]
grant administer database trigger to <user>
[/code]

Cheers!!