Set Someone’s Permissions in SQL

Grant, revoke and Deny are the 3 keywords used to apply permissions. To learn more about it, check out these links.

http://www.databasejournal.com/features/mssql/article.php/2246271/Managing-Users-Permissions-on-SQL-Server.htm

http://www.mssqltips.com/sqlservertip/1718/database-level-permissions-for-sql-server-2005-and-2008/

http://msdn.microsoft.com/en-us/library/w1bhybwz(v=vs.80).aspx

http://blogs.msdn.com/b/lcris/archive/2007/09/12/basic-sql-server-security-concepts-permissions-and-special-principals-sa-dbo-guest.aspx?Redirected=true

http://www.exforsys.com/tutorials/sql-server-2005/sql-server-permissions.html

Hope it helps u out.
Thank u!!!