sp_addlogin

sp_addlogin loginame, passwd [,defdb[, deflanguage [,fullname]]]

 

examples

 

1.sp_addlogin ppzlyg ,meijia,beatrice

 create an adaptive server login for "ppzlyg" with the password"meijia" and the

 default database beatrice

 

2.sp_addlogin ppzlyg,meijia,beatrice_db,french

 create an adaptive server login for "ppzlyg" password is "meijia" default database

 is beatrice_db,and default language is french

 

3.sp_addlogin ppzlyg,meijia,beatrice_db,null,"pan pin zhou"

 create an adaptive server login for "ppzlyg" password is "meijia" default database

 is beatrice_db,and full name is "pan pin zhou" do not enclose null in quotes.

 

4.sp_addlogin ppzlyg,meijia,null,null," pan pin zhou"

  create an adaptive server login for "ppzlyg" password is "meijia" and full name

  is "pan pin zhou" and the server's default database and language .do not enclose

  null in quotes.

 

5.sp_addlogin ppzlyg,meijia,"pan pin zhou"

 

 

 

comments

. after assigning a default database to a user with sp_addlogin,the database owner

  or system administrator must provide access to the database by executing 

  sp_adduser or sp_addalias.

 

.although a user can use sp_modifylogin to change his or her own default database

 at any time,a database cannot be used without permission form the database owner

 

.a user can use sp_password at any time to change his or her own password. a system

 security officer can use sp_password to change any use's passowrd

 

.a user can use sp_modifylogin to change his or her own default language. a system

administrator can sp_modifylogin to change any user's default language

 

. a user can use sp_modifylogin to change his or her own fullname.a system

  administrator can use sp_modifylogin to change any user's fullname