What should i do for getting knowledge of database security for different-2 users

Transact-SQL
1

I want to know that how can i provide authority and use security. for different -2 users like,dba,developer,admin etc in sql server