{"id":3751,"date":"2024-03-13T07:24:33","date_gmt":"2024-03-13T07:24:33","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/"},"modified":"2025-07-30T20:40:28","modified_gmt":"2025-07-30T20:40:28","slug":"how-to-create-a-user-and-grant-permissions-in-sql-server","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/","title":{"rendered":"SQL Server User Creation Guide"},"content":{"rendered":"<p>To create a user and grant permissions in SQL Server, you can follow these steps:<\/p>\n<ol>\n<li>First, log in to SQL Server Management Studio (SSMS) using an administrator account.<\/li>\n<li>Choose the database where you want to create the user, then right-click on the database and select &#8220;New Query&#8221;.<\/li>\n<li>Enter the following code in the query window to create a new user and assign a password:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">CREATE<\/span> LOGIN [\u7528\u6237\u540d] <span class=\"hljs-keyword\">WITH<\/span> PASSWORD <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-string\">'\u5bc6\u7801'<\/span>;\r\n<\/code><\/pre>\n<p>Please replace &#8220;username&#8221; with the username you wish to create, and replace &#8220;password&#8221; with the user&#8217;s password.<\/p>\n<ol>\n<li>Next, create a database user for the newly created user.<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code>USE [\u60a8\u7684\u6570\u636e\u5e93\u540d\u79f0];\r\n<span class=\"hljs-keyword\">CREATE<\/span> <span class=\"hljs-keyword\">USER<\/span> [\u7528\u6237\u540d] <span class=\"hljs-keyword\">FOR<\/span> LOGIN [\u7528\u6237\u540d];\r\n<\/code><\/pre>\n<ol>\n<li>Finally, grant permissions to the user. You can use the GRANT statement to grant different permissions to the user, such as SELECT, INSERT, UPDATE, DELETE, and so on. For example, if you want to give a user SELECT permission on a specific table, you can use the following command:<\/li>\n<\/ol>\n<pre class=\"post-pre\"><code>USE [\u60a8\u7684\u6570\u636e\u5e93\u540d\u79f0];\r\n<span class=\"hljs-keyword\">GRANT<\/span> <span class=\"hljs-keyword\">SELECT<\/span> <span class=\"hljs-keyword\">ON<\/span> [\u8868\u540d] <span class=\"hljs-keyword\">TO<\/span> [\u7528\u6237\u540d];\r\n<\/code><\/pre>\n<p>By following the steps above, you can successfully create a user and assign permissions. Please note that in order to complete these actions, you need to have sufficient privileges.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To create a user and grant permissions in SQL Server, you can follow these steps: First, log in to SQL Server Management Studio (SSMS) using an administrator account. Choose the database where you want to create the user, then right-click on the database and select &#8220;New Query&#8221;. Enter the following code in the query window [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[390,2151,2498,572,1297],"class_list":["post-3751","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-administration","tag-database-security","tag-sql-permissions","tag-sql-server","tag-user-management"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Server User Creation Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to create users and grant permissions in SQL Server with our step-by-step guide. Includes code examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server User Creation Guide\" \/>\n<meta property=\"og:description\" content=\"Learn how to create users and grant permissions in SQL Server with our step-by-step guide. Includes code examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-13T07:24:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-30T20:40:28+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin Taylor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin Taylor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/\"},\"author\":{\"name\":\"Benjamin Taylor\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9\"},\"headline\":\"SQL Server User Creation Guide\",\"datePublished\":\"2024-03-13T07:24:33+00:00\",\"dateModified\":\"2025-07-30T20:40:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/\"},\"wordCount\":175,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database administration\",\"database security\",\"SQL permissions\",\"sql server\",\"user management\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/\",\"name\":\"SQL Server User Creation Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-13T07:24:33+00:00\",\"dateModified\":\"2025-07-30T20:40:28+00:00\",\"description\":\"Learn how to create users and grant permissions in SQL Server with our step-by-step guide. Includes code examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server User Creation Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9\",\"name\":\"Benjamin Taylor\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g\",\"caption\":\"Benjamin Taylor\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL Server User Creation Guide - Blog - Silicon Cloud","description":"Learn how to create users and grant permissions in SQL Server with our step-by-step guide. Includes code examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server User Creation Guide","og_description":"Learn how to create users and grant permissions in SQL Server with our step-by-step guide. Includes code examples.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-13T07:24:33+00:00","article_modified_time":"2025-07-30T20:40:28+00:00","author":"Benjamin Taylor","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Benjamin Taylor","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/"},"author":{"name":"Benjamin Taylor","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9"},"headline":"SQL Server User Creation Guide","datePublished":"2024-03-13T07:24:33+00:00","dateModified":"2025-07-30T20:40:28+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/"},"wordCount":175,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database administration","database security","SQL permissions","sql server","user management"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/","name":"SQL Server User Creation Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-13T07:24:33+00:00","dateModified":"2025-07-30T20:40:28+00:00","description":"Learn how to create users and grant permissions in SQL Server with our step-by-step guide. Includes code examples.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-create-a-user-and-grant-permissions-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server User Creation Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/ac801fe9549a25960ce48aa2e0a691c9","name":"Benjamin Taylor","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ec2e3d3e2d525fd148047c4520ae7c1cdccd1f4b48a1a488422b31f04f345c14?s=96&d=mm&r=g","caption":"Benjamin Taylor"},"url":"https:\/\/www.silicloud.com\/blog\/author\/benjamintaylor\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/3751","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=3751"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/3751\/revisions"}],"predecessor-version":[{"id":148416,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/3751\/revisions\/148416"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=3751"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=3751"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=3751"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}