Symptom
Ownership inconsistencies for ASE database thresholds may result in any of various errors including:
- If the threshold owner does not have permission to execute the threshold procedure:
Error: 10330, Severity: 14, State: 1
EXECUTE permission denied on object sp_thresholdaction, database sybsystemprocs, owner dbo
Threshold procedure 'sp_thresholdaction' returned an error indication (@status=-4) when called for database 'mydb', segment 'logsegment', free_space 4611686018427393024.
- When attempting to remove a login from ASE when that login owns a database threshold:
Msg 17509, Level 16, State 1:
Server 'SYBASE', Procedure 'sp_droplogin', Line 146:
User exists or is an alias or is a database owner in at least one database. Drop the user or the alias, or change the database ownership before dropping the login.
- When attempting to remove a user from a given database when that user owns a database threshold:
Msg 18033, Level 16, State 1:
Server 'SYBASE', Procedure 'sp_dropuser', Line 354:
You cannot drop user because user 'myuser' owns thresholds in database.
Segment name Free pages
------------------------------ -----------
logsegment 15016
- When attempting to remove a user alias from a given database when that alias owns a database threshold:
Msg 18806, Level 16, State 1:
Server 'SYBASE', Procedure 'sp_dropalias', Line 183:
You cannot drop the alias for login 'myuser' because 'myuser' owns thresholds in the database.
Segment name Free pages
------------------------------ -----------
logsegment 261136
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) all versions
Product
SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions
Keywords
systhresholds, sp_modifythreshold , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.