Deleting user objects

select users_id, prevlastsession from users where
prevlastsession is null and registertype = 'G'

If this SQL query returns one or more records, run the following SQL statement to populate the PREVLASTSESSION column within the USERS database table:

• 

  update users set prevlastsession = current timestamp - timestamp_value where prevlastsession is null and registertype = 'G'

  For example, to set the time stamp to be 30 days before the current date, run the following statement:

  update users set prevlastsession = current timestamp - 30
  days where prevlastsession is null and registertype =
  'G'

• 

  update users set prevlastsession = sysdate - timestamp_value where prevlastsession is null and registertype = 'G' ; 

  For example, to set the time stamp to be 30 days before the current date, run the following statement:

  update users set prevlastsession = sysdate - 30 days where
  prevlastsession is null and registertype = 'G' ;