Create a login name using SQL statements and assign permissions to the specified database

1. Create a login name:

1 Use Test
2 Exec Sp_addlogin ' Userid ' , ' Password '
3 Go

2. Create a user name for the specified database:

1 Use Test
2 Exec Sp_grantdbaccess ' Userid ' , ' Userid '
3 Go  

3. Assign the specified database permission to the specified user:

1 Use Test
2 Grant   Create   Table , Insert , Delete , Update , Select   To Userid
3 Go  

4. Add a database role:

1 Use Test
2 Exec Sp_addrole ' Role '
3 Go

5. Add the Member member whose role is role:

1 Use Test
2 Exec Sp_addrolemember ' Role ' , ' Member '
3 Go  

6. Set the role to have the update permission for the table:

1 Use Test
2 Grant   Update   On   Table   To Role
3 Go