Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    Canada
    Posts
    7

    Unanswered: Drop user that own thresholds

    I'm trying to drop a user and I get this message:

    DBArtisan
    ---------------------------
    You cannot drop user because user 'Rdave' owns thresholds in database.
    ---------------------------

    Any ideas of how to drop this user?

    Thanx

  2. #2
    Join Date
    Nov 2003
    Location
    Zurich, Switzerland
    Posts
    7

    Thumbs up threshhold actions

    What you need to do is get the suid from the sysusers for the user you are dropping, then look into systhresholds and run this query:

    select * from sysusers where name = "<name u are dropping>"

    select * from systhresholds where suid = (the suid you retrieved for the user you were dropping in sysusers).

    What has probably happened is somebody created a threshold as their own user on a db, this can cause the log to fill up if the user does not exists if the "trunc log on checkpoint" option is disabled.

    So update the suid to sa (1) on the suid of the threshold that is owned by the user. If sa is locked, then in some versions of sybase thresholds won't work if the sa user is locked.

    update systhresholds set suid = 1

    don't forget sp_configure "allow updates", 1 before ouching sys tablesa and then set to 0 once complete

  3. #3
    Join Date
    Aug 2003
    Location
    Canada
    Posts
    7
    It worked nicely. Thank you for your help

Posting Permissions

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