The syntax is the same

grant select on table to user

youll need to set up the sqlserver login and database user separtly though. The security models different to oracle.

And no im not a microsoft nancy boy