{"id":1212,"date":"2024-03-25T06:45:00","date_gmt":"2024-03-25T05:45:00","guid":{"rendered":"https:\/\/expert-only.com\/prep\/?p=1212"},"modified":"2024-03-27T08:46:33","modified_gmt":"2024-03-27T07:46:33","slug":"creer-un-utilisateur-sql-server-avec-ssms","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/","title":{"rendered":"Comment Cr\u00e9er un Utilisateur SQL Server avec SSMS ?"},"content":{"rendered":"\n<p>Dans ce tutoriel SQL Server, voici comment cr\u00e9er un login utilisateur SQL Server avec l&rsquo;interface graphique de SSMS. Le but est de donner acc\u00e8s aux bases de donn\u00e9es d&rsquo;une instance donn\u00e9e.<\/p>\n\n\n\n<p>Le login d&rsquo;un utilisateur permet d&rsquo;avoir acc\u00e8s \u00e0 une ou plusieurs bases SQL. La gestion de la s\u00e9curit\u00e9 dans SQL Server est une t\u00e2che qui revient en g\u00e9n\u00e9ral aux administrateurs de base de donn\u00e9es. Ils sont appel\u00e9s DataBase Administrator (DBA) en Anglais. Et c&rsquo;est le domaine appel\u00e9 <a href=\"https:\/\/expert-only.com\/fr\/dba\/\">DataBase Administration<\/a>.<\/p>\n\n\n\n<p>Voici donc comment cr\u00e9er de nouveaux identifiants pour un utilisateur sous SQL Server. Bien s\u00fbr, il est aussi possible de <a href=\"https:\/\/expert-only.com\/fr\/dba\/creer-une-base-sql-server-avec-un-script\/\">cr\u00e9er un login avec un script SQL<\/a>.<\/p>\n\n\n\n<p class=\"has-text-align-center\"><strong>Les captures d&rsquo;\u00e9crans proviennent d&rsquo;une installation en Anglais.<\/strong><\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#1-ouvrir-ssms-et-le-menu-pour-creer-un-login\" >1. Ouvrir SSMS et le menu pour cr\u00e9er un login<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#2-configurer-le-login-sql-server\" >2. Configurer le login SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#3-ajouter-des-roles-au-login-sql-server\" >3. Ajouter des r\u00f4les au login SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#4-configurer-le-mapping-du-login-sur-les-bases-sql\" >4. Configurer le mapping du login sur les bases SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#5-finaliser-la-creation-du-compte-sql-server\" >5. Finaliser la cr\u00e9ation du compte SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#conclusion\" >Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"1-ouvrir-ssms-et-le-menu-pour-creer-un-login\"><\/span>1. Ouvrir SSMS et le menu pour cr\u00e9er un login <span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Premi\u00e8re \u00e9tape, ouvrir SQL Server Management Studio. Une base de donn\u00e9es est visible et accessible depuis l&rsquo;interface SSMS.<\/p>\n\n\n\n<p>Dans notre cas, la base est nomm\u00e9e <strong>DB-Expert-Only.<\/strong> Pour cr\u00e9er un nouveau compte utilisateur, suivre les 3 \u00e9tapes ci-dessous:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Depuis <strong>Security<\/strong><\/li>\n\n\n\n<li>Faire un clic-droit sur le sous-dossier <strong>Logins<\/strong>.<\/li>\n\n\n\n<li>Cliquer maintenant sur <strong>New Login<\/strong>.<\/li>\n<\/ol>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"971\" height=\"702\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login.jpg\" alt=\"Cr\u00e9er un login utilisateur SQL Server avec SSMS \" class=\"wp-image-1215\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login.jpg 971w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login-300x217.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login-768x555.jpg 768w\" sizes=\"auto, (max-width: 971px) 100vw, 971px\" \/><figcaption class=\"wp-element-caption\"><em>Cr\u00e9er un login utilisateur SQL Server avec SSMS <\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2-configurer-le-login-sql-server\"><\/span>2. Configurer le login SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Une fois la fen\u00eatre ouverte:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Dans la fen\u00eatre <strong><em>Login &#8211; New<\/em><\/strong> entrer les identifiants, dans ce cas, c&rsquo;est <strong>US-Expert-Only<\/strong>.<\/li>\n\n\n\n<li>Ensuite choisir <strong><em>SQL Server authentication<\/em><\/strong> et entrer le mot de passe deux fois.<\/li>\n\n\n\n<li>Puis d\u00e9cocher <strong><em>Enforce password expiration<\/em><\/strong> afin que le mot de passe n&rsquo;expire jamais. Cette r\u00e8gle est \u00e0 mettre en place en fonction des besoins de s\u00e9curit\u00e9.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"972\" height=\"702\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/2_SQL_Server_2005_new_login_password.jpg\" alt=\"Entrer le nom de l'utilisateur et le mot de passe SQL Server dans SSMS\" class=\"wp-image-1216\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/2_SQL_Server_2005_new_login_password.jpg 972w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/2_SQL_Server_2005_new_login_password-300x217.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/2_SQL_Server_2005_new_login_password-768x555.jpg 768w\" sizes=\"auto, (max-width: 972px) 100vw, 972px\" \/><figcaption class=\"wp-element-caption\"><em>Entrer le nom de l&rsquo;utilisateur et le mot de passe SQL Server dans SSMS<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3-ajouter-des-roles-au-login-sql-server\"><\/span>3. Ajouter des r\u00f4les au login SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Maintenant, dans l&rsquo;onglet Server Roles cocher le bouton sysadmin, noter que le compte cr\u00e9\u00e9 aura alors tous les droits sur l&rsquo;instance de base de donn\u00e9es SQL Server.<\/p>\n\n\n\n<p>C&rsquo;est \u00e0 dire que le nouveau login aura <strong><em>tous les privil\u00e8ges<\/em><\/strong> sur cette base de donn\u00e9es de test.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"972\" height=\"702\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/3_SQL_Server_2005_new_server_roles.jpg\" alt=\"Attribuer le r\u00f4le sysadmin sur la base SQL Server\" class=\"wp-image-1217\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/3_SQL_Server_2005_new_server_roles.jpg 972w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/3_SQL_Server_2005_new_server_roles-300x217.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/3_SQL_Server_2005_new_server_roles-768x555.jpg 768w\" sizes=\"auto, (max-width: 972px) 100vw, 972px\" \/><figcaption class=\"wp-element-caption\">Attribuer le r\u00f4le sysadmin sur la base SQL Server<\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4-configurer-le-mapping-du-login-sur-les-bases-sql\"><\/span>4. Configurer le mapping du login sur les bases SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Afin d&rsquo;assigner le compte cr\u00e9\u00e9 aux bases de donn\u00e9es, cette fois: <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Cliquer sur <strong>User Mapping<\/strong>, sont alors affich\u00e9es toutes les bases de donn\u00e9es existantes.<\/li>\n\n\n\n<li>S\u00e9lectionner une base de donn\u00e9es, alors la liste des utilisateurs de la base s&rsquo;affiche, comme ci-dessous.<\/li>\n\n\n\n<li>Cliquer alors sur la base de donn\u00e9es <strong>master<\/strong><\/li>\n\n\n\n<li>Cocher <strong>db_owner<\/strong> et <strong>public<\/strong>, puis valider.<\/li>\n<\/ol>\n\n\n\n<p><strong>Noter que le r\u00f4le db_owner est un r\u00f4le d&rsquo;administrateur avec tous les privil\u00e8ges sur ces bases.<\/strong><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"669\" height=\"600\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/4_SQL_Server_2005_database_login_assignment.jpg\" alt=\"Cocher db_owner pour le login SQL Server\" class=\"wp-image-1218\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/4_SQL_Server_2005_database_login_assignment.jpg 669w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/4_SQL_Server_2005_database_login_assignment-300x269.jpg 300w\" sizes=\"auto, (max-width: 669px) 100vw, 669px\" \/><figcaption class=\"wp-element-caption\"><em>Cocher db_owner pour le login SQL Server<\/em><\/figcaption><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"5-finaliser-la-creation-du-compte-sql-server\"><\/span>5. Finaliser la cr\u00e9ation du compte SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Toutes les configurations n\u00e9cessaires sont effectu\u00e9es, dans l&rsquo;onglet <strong>Securables<\/strong>, cliquer simplement sur <strong><em>OK<\/em><\/strong>. C&rsquo;est la derni\u00e8re \u00e9tape de cr\u00e9ation d&rsquo;un nouvel utilisateur SQL Server avec <a href=\"https:\/\/en.wikipedia.org\/wiki\/SQL_Server_Management_Studio\" target=\"_blank\" rel=\"noreferrer noopener\">SSMS<\/a>.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"972\" height=\"702\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/5_SQL_Server_2005_database_login_securables.jpg\" alt=\"Valider la cr\u00e9ation de l'utilisateur\" class=\"wp-image-1219\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/5_SQL_Server_2005_database_login_securables.jpg 972w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/5_SQL_Server_2005_database_login_securables-300x217.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/5_SQL_Server_2005_database_login_securables-768x555.jpg 768w\" sizes=\"auto, (max-width: 972px) 100vw, 972px\" \/><figcaption class=\"wp-element-caption\"><em>Valider la cr\u00e9ation de l&rsquo;utilisateur<\/em><\/figcaption><\/figure><\/div>\n\n\n<p>Le nouveau login d&rsquo;utilisateur US-Expert-Only apparait d\u00e9sormais dans la liste des logins de l&rsquo;instance SQL. Le syst\u00e8me liste les nouveaux identifiants apr\u00e8s la cr\u00e9ation d&rsquo;un login SQL Server.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter\"><img loading=\"lazy\" decoding=\"async\" width=\"972\" height=\"702\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/6_SQL_Server_2005_logins_list.jpg\" alt=\"\" class=\"wp-image-1220\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/6_SQL_Server_2005_logins_list.jpg 972w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/6_SQL_Server_2005_logins_list-300x217.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/6_SQL_Server_2005_logins_list-768x555.jpg 768w\" sizes=\"auto, (max-width: 972px) 100vw, 972px\" \/><\/figure><\/div>\n\n\n<p>Ensuite, pour tester l&rsquo;acc\u00e8s, se connecter avec le nouveau login en tant qu&rsquo;utilisateur autoris\u00e9. Cliquer simplement sur <strong>File<\/strong> puis <strong>Connect<\/strong>, et entrer l&rsquo;identifiant et le mot de passe, puis cliquer \u00e0 nouveau sur <strong>Connect<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\"><span class=\"ez-toc-section\" id=\"conclusion\"><\/span>Conclusion<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Enfin, ce tutoriel explique comment cr\u00e9er un login utilisateur SQL Server avec SSMS, \u00e9tapes par \u00e9tapes et depuis l&rsquo;interface graphique, donc sans aucun script.<\/p>\n\n\n\n<p>De nombreuses autres fonctions sont disponibles et permettent <a href=\"https:\/\/expert-only.com\/fr\/ssms\/option-ssms-verifier-objet-existe\/\">de v\u00e9rifier l&rsquo;existance d&rsquo;un objet dans les scripts g\u00e9n\u00e9r\u00e9s par SSMS<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"uFKMyCdd92\"><a href=\"https:\/\/expert-only.com\/fr\/dba\/afficher-la-version-exacte-sql-server\/\">Afficher la version exacte de SQL Server avec une requ\u00eate<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Afficher la version exacte de SQL Server avec une requ\u00eate\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/dba\/afficher-la-version-exacte-sql-server\/embed\/#?secret=Jg0Wu4ZqxZ#?secret=uFKMyCdd92\" data-secret=\"uFKMyCdd92\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Dans ce tutoriel SQL Server, voici comment cr\u00e9er un login utilisateur SQL Server avec l&rsquo;interface graphique de SSMS. Le but est de donner acc\u00e8s aux bases de donn\u00e9es d&rsquo;une instance donn\u00e9e. Le login d&rsquo;un utilisateur permet d&rsquo;avoir acc\u00e8s \u00e0 <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/\" title=\"Comment Cr\u00e9er un Utilisateur SQL Server avec SSMS ?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[352],"tags":[53],"class_list":{"0":"post-1212","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-dba","7":"tag-create"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Comment Cr\u00e9er un Utilisateur SQL Server avec SSMS ? DBA<\/title>\n<meta name=\"description\" content=\"Pour cr\u00e9er un utilisateur SQL Server avec SSMS, depuis l&#039;interface graphique, entrer le login, le mot de passe et assigner les r\u00f4les.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment Cr\u00e9er un Utilisateur SQL Server avec SSMS ?\" \/>\n<meta property=\"og:description\" content=\"Pour cr\u00e9er un utilisateur SQL Server avec SSMS, depuis l&#039;interface graphique, entrer le login, le mot de passe et assigner les r\u00f4les.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-25T05:45:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-27T07:46:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login.jpg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Comment Cr\u00e9er un Utilisateur SQL Server avec SSMS ?\",\"datePublished\":\"2024-03-25T05:45:00+00:00\",\"dateModified\":\"2024-03-27T07:46:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/\"},\"wordCount\":649,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login.jpg\",\"keywords\":[\"create\"],\"articleSection\":[\"Administration SQL Server\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/\",\"url\":\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/\",\"name\":\"Comment Cr\u00e9er un Utilisateur SQL Server avec SSMS ? DBA\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login.jpg\",\"datePublished\":\"2024-03-25T05:45:00+00:00\",\"dateModified\":\"2024-03-27T07:46:33+00:00\",\"description\":\"Pour cr\u00e9er un utilisateur SQL Server avec SSMS, depuis l'interface graphique, entrer le login, le mot de passe et assigner les r\u00f4les.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Comment Cr\u00e9er un Utilisateur SQL Server avec SSMS ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Comment Cr\u00e9er un Utilisateur SQL Server avec SSMS ? DBA","description":"Pour cr\u00e9er un utilisateur SQL Server avec SSMS, depuis l'interface graphique, entrer le login, le mot de passe et assigner les r\u00f4les.","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:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/","og_locale":"fr_FR","og_type":"article","og_title":"Comment Cr\u00e9er un Utilisateur SQL Server avec SSMS ?","og_description":"Pour cr\u00e9er un utilisateur SQL Server avec SSMS, depuis l'interface graphique, entrer le login, le mot de passe et assigner les r\u00f4les.","og_url":"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-03-25T05:45:00+00:00","article_modified_time":"2024-03-27T07:46:33+00:00","og_image":[{"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login.jpg","type":"","width":"","height":""}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Comment Cr\u00e9er un Utilisateur SQL Server avec SSMS ?","datePublished":"2024-03-25T05:45:00+00:00","dateModified":"2024-03-27T07:46:33+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/"},"wordCount":649,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login.jpg","keywords":["create"],"articleSection":["Administration SQL Server"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/","url":"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/","name":"Comment Cr\u00e9er un Utilisateur SQL Server avec SSMS ? DBA","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login.jpg","datePublished":"2024-03-25T05:45:00+00:00","dateModified":"2024-03-27T07:46:33+00:00","description":"Pour cr\u00e9er un utilisateur SQL Server avec SSMS, depuis l'interface graphique, entrer le login, le mot de passe et assigner les r\u00f4les.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/1_SQL_Server_2005_create_new_login.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/dba\/creer-un-utilisateur-sql-server-avec-ssms\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Comment Cr\u00e9er un Utilisateur SQL Server avec SSMS ?"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1212","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=1212"}],"version-history":[{"count":2,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1212\/revisions"}],"predecessor-version":[{"id":31032,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/1212\/revisions\/31032"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=1212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=1212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=1212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}