In client/server systems, more developers PCs connected to a same SQL Server database Pc using TCP/IP

how to give this connectivity and giving limited permissions to client pcs using sqlserver queries