Triggers won't do this for you, since there's no operation to trigger them.<BR><BR>Why not have a scheduled job (perhaps run nightly) that updates the status of all rows where the expiration date ...

The After Logon database trigger is a convenient way to initialize a user session by setting application context values for it. This Oracle tip shows you why—and how—it's done.