I have some aliased users and want to delete them and create them again as normal users, not as aliased. Then I have to assign them to the same db's they were assigned to, and make them members of a specified group.
Here's the code:
CREATE PROCEDURE sp_delaliases AS
set nocount on
declare @sid varbinary(85),
insert into #da select name,sid,db_name() from sysusers where isaliased=1
select * from #da
--This is the list of all aliases and the db's they are assigned to.
Now how to go further?
May I need some code from the sp_adduser and/or from any other sp's?
Or can I simply put the names into variables, and execute the sp_adduser for them? If yes then how? (I haven't got enough experience in this)