Creating New User - Sql2005

Creating New User - Sql2005 · **samuel** on Fri 7 Nov - 18:51

Creating New Login in Restored Database:

While Creating a new user in the restored Database following steps are to be followed,

Deleting user:

Double click on the Username in Scema under Security and rename the default schema name to dbo then press ok
delete the user

Creating user
Now Create a new login user will be automatically created.

Finally change the dbo schema to database scema