PUP table 2004-08-12 - By Tim Gorman
Unfortunately (or rather, fortunately), a failure in an AFTER LOGON trigger
does not do anything to interfere with the session...
SQL > connect scott/tiger
Connected.
SQL > create or replace trigger x
2 after logon
3 on schema
4 begin
5 raise_application_error(-20000, 'raise error ');
6 end x;
7 /
Trigger created.
SQL > connect scott/tiger
Connected.
SQL >
However, in the "alert.log ", it says:
Thu Aug 12 21:43:03 2004
Errors in file /Users/oracle/base/admin/TST1/udump/tst1_ora_8963.trc:
ORA-00604 (See ORA-00604.ora-code.com): error occurred at recursive SQL level 1
ORA-20000 (See ORA-20000.ora-code.com): AFTER LOGIN trigger exception
ORA-06512 (See ORA-06512.ora-code.com): at line 2
And the trace file isn 't much more helpful than that...
on 8/12/04 3:02 PM, Gogala, Mladen at Mladen.Gogala@(protected) wrote:
> Well, you can also create a login trigger which will look into
> the "module " column of V$SESSION and raise an exception if
> that column has a value of "Toad " or "SQL*Plus ". That would be
> much more effective then PRODUCT_USER_PROFILE.
>
> --
> Mladen Gogala
> Oracle DBA
> email:mladeng@(protected)
> Ext: 9787
>
>
> > -- --Original Message-- --
> > From: Bobak, Mark [mailto:Mark.Bobak@(protected)]
> > Sent: Thursday, August 12, 2004 4:55 PM
> > To: oracle-l@(protected)
> > Subject: RE: PUP table
> >
> >
> > David,
> >
> > As you discovered, PRODUCT_USER_PROFILE only limits people
> > using = SQL*Plus as the client tool. TOAD does not look at
> > or care about the = contents of the PRODUCT_USER_PROFILE
> > table. If you want to restrict = non-SQL*Plus users from
> > certain activities, you 'll have to revoke = privleges and
> > roles from the user(s).
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
> To unsubscribe send email to: oracle-l-request@(protected)
> put 'unsubscribe ' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe ' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
