Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    26

    Unanswered: disappearing users

    I am running version 12.5.0.3 on HP-UX. I have a Sybase server that has 3 databases.... a prod, previous_day and start_of_day. The prod database is copied to the other two. I have a script that saves off the users and aliases on the previous_day and start_of_day databases, loads the database, then loads back the users and aliases. Now, I am seeing no errors in my log but, every now and then, my aliases or users will disappear.

    Now, I am not asking anyone to figure out my problem, I am just wondering if there is a way for me to audit, or set a flag or something to tell me when a user or alias in a database is dropped ? Thanks.

    DB
    Dogboy

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    You could install Sybase auditing (the sybsecurity database) and audit any modifications of the sysusers table.

    Michael

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •