Aliased users

• Logan Fergus

  SSC-Addicted

  Points: 431

  More actions

  February 16, 2007 at 11:16 am

  #98167

  Hi there, hoping someone will have some insight as I am not having much luck. I recently moved a database from one sql 2000 server to another and after the move there were a lot of orphaned users that I 'fixed' using sp_change_users_login.

   

  The database is for the application SASIxp if anyone is familiar with it. It uses aliases ( arrrgh ) instead of roles.

  I can see all the alias accounts in the sysuser table but if I try sp_dropalias QA says "No alias exists for the specified user". Then I run sp_addalias and it says "User or role '\cwilson' already exists in the current database".

   

  Seems the link between the SASI account and the user accounts is broke?

   

  Anyone ever have a situation like this. Anyway to get rid of the aliased accounts and redo them?

   

  Please help.

• February 19, 2007 at 8:00 am

  This was removed by the editor as SPAM

• Salil Sunil Sule-353027

  SSC Enthusiast

  Points: 163

  More actions

  February 22, 2007 at 4:40 am

  #691112

   Hi,

   I have also not faced problem like this but one

   WAY IS THERE BY WHICH U CAN ABLE TO FIND OUT THE CORRECT ALIASES AND THEN DROP THAT ALIASES.

   There is a stored procedure

  1. sp_helplogins which Returns a list of valid login values

  2.After this u can use sp_helpuser which Returns a list of valid alias_user values in the database in which the login is used.

  3.After the comparison u can use sp_dropalias

  which Removes an alias mapping.

  Hope this will serve ur purpose.