无法删除用户

alexsenfei · 发表于 2007-3-29 10:21

Server Message:  Number  18033, Severity  16
You cannot drop user because user 'test' owns thresholds in database.
(1 row affected)
(1 row affected)
(return status = 1)

Segment name                Free pages
------------                -----------
logsegment                         270016

alexsenfei · 发表于 2007-3-29 10:22

sp_helpuser test
Users_name ID_in_db Group_name Login_name
---------- ----------- ---------- ----------
test 23 public sa

alexsenfei · 发表于 2007-3-29 10:24

应该是LOGIN 为SA的原因.但不知道怎么解决.
斑竹是否能帮忙呢,..

alexsenfei · 发表于 2007-3-30 08:12

不要沉

ggpl · 发表于 2007-3-30 09:27

用sp_helpdb看一下有那些db，然后每个db都检查一下，有没有sa建过的thresholds存储过程，找到后删除掉就可以把test用户删除了

alexsenfei · 发表于 2007-3-30 10:49

怎么查有没SA建过的threshold存储过程.这个删掉后再建需要重起SYBASE么?

ggpl · 发表于 2007-3-30 11:03

sa登录后
use dbname
go
select name from sysobjects where name='sp_thresholdaction'
go
如果有，用sp_helptext sp_thresholdaction
看看内容，然后drop procedure sp_thresholdaction
各个db都看过了，就可以drop user了，当然drop user后最好把前面删除的sp_thresholdaction再重建一下，脚本就是前面helptext看到的

alexsenfei · 发表于 2007-3-30 11:17

每个库都没有.

是不是要DROP THRESHOLD.

ggpl · 发表于 2007-3-30 17:19

官方网站的解释
Error 18033
Severity

0

Error message text
You cannot drop user because user '%1!' owns thresholds in database.

Explanation
The user who created a threshold or last modified a threshold is the threshold owner. A user who owns a threshold cannot be dropped. Error 18033 occurs when you use sp_dropuser to try to drop a user who owns a threshold.

Action
You have three options:

Drop the threshold procedure owned by the user. Then you can drop the user.

Have another user with appropriate privileges modify the threshold. Then you can drop the user.

If you want to inactivate the user Adaptive Server login while leaving the threshold active, use sp_locklogin to prevent use of the login.

应该是还有存储过程没有删除，检查一下你的sql拼写是否正确，或者你用select * from systhresholds
看一下，有没有记录