drop user

Hot Topic

Passing a variable to the UPDATE Command
Report's Parameter : From Date to Date
Commercial Application using MSDE or SQL Server 2005 Express
RS 2005: Excessively Long String error when printing
SQL Agent and DTExec
multiple calls to SP
Clearing/Unselecting Multi-Value selections made
DTS Wizard SQL 2005 - Enable Identity Insert
subreport parameters not pulling data right
Capturing Error Information

SQL Server

An internal error occurred on the report server. See the error log for more details.
Can't Create New Database on Device via ActiveSync
Management Studio Express CTP update now available
best approach
ReportService.asmx vs. ReportService2005.asmx
Report builder functions
Error installing SQL Server 2005 Express Manager
Data flow is locking up
Sql Server Encryption
SQL and Record Count and Web service

drop user

Hi,

I have a user in my SQL server 2005 database sys.sysusers table with following values.

I am unable to delete this user and unable to create a user with this same user name.

Please tell some one what is status=16 and issqluser=0

status    16

ame      \CMSXXCMSTESTER< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

roles     NULL

altuid    5   

hasdbaccess     0

 islogin             1

isntname           0

isntgroup          0

isntuser            0

issqluser           0

isaliased            1

issqlrole            0

isapprole          0

 

When I tried delete the user using sp_dropuser it says the user doesnt exist or u do not have permissions. later is not correct as i have all permissions as I am admin.

And i also tried sp_change_users_login 'report' but I can't see the user in question.

Please tell me what is status=16 and how a record like this present in table which doesnt allow to delete nor allow to create with same name.

I want to drop this user some how..

Thanks

Answer this question

drop user

  • matteo raumer

    Hi

    COuld you please post the results of the sp_helpuser command.

    regards

    Jag



  • Kumarchill

    I am having the same problem as the OP. sp_dropalias does not work either. Is there any was to remove these records from sys.sysusers. I would like to be able to use the user name that is being held hostage by the status 16.

  • Ehab H.GEDDAWY

    Hello,

    It seems that the account is aliased.  execute sp_dropalias.

    Hope that helps.

    Cheers

    Rob

  • SRIKANTHPRAGADA

    Is the user name with status = 16 a windows user or group

  • aserbert

    I am having the same problem. I have a user '\import' in the database with a status of 16. I cannot drop it as a either user or an alias. I have no idea how the user got on the database (it was there before I took the job) - so I have no idea if it was a user or a group.
  • drop user
Answer this question