Symptom
- Unable to drop login with alias to dbo in a database and owning objects
- Error(s) raised when trying to drop login that still owns object via alias:
sp_droplogin mylogin
go
Msg 19587, Level 16, State 1:
Server 'ASE', Procedure 'sp_droplogin', Line 376:
User exists or is an alias or is a database owner in 'db_name' database(s).
drop login mylogin
go
The login 'mylogin' is still a user, alias or database owner in 'db_name' database.
Msg 3770, Level 16, State 1:
The DROP login 'mylogin' failed. See previous messages for more information.sp_dropalias mylogin
go
Msg 18790, Level 16, State 1:
Server 'ASE', Procedure 'sp_dropalias', Line 204:
You cannot drop the alias for login 'mylogin' because 'mylogin' owns objects in the database.
(followed by listing of objects owned)
name type
------------------------------- -----
abc U
Read more...
Environment
SAP Adaptive Server Enterprise (ASE)
Product
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
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.