Set Someone’s Permissions in SQL

Question

Hi Friends What are SQL keywords used to change or set someone's permissions in SQL ?

Shivanand Arur · Answer

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!!!

Satyapriya Nayak · Answer

GRANT DENY and REVOKE