Differences

This shows you the differences between two versions of the page.

--- ssms_notes [2022/12/21 19:46] – raju
+++ ssms_notes [2022/12/21 19:50] (current) – prasanthi
@@ Line 5: / Line 5: @@
   * To install start SSMS -> object explorer -> Databases -> right click -> "Restore Database..." -> Device -> ... -> Backup media type: -> choose "File" -> Add -> Choose the .bak file -> OK -> OK -> OK
   * For other users to access it
-    * SSMS -> Object explorer -> Security -> Logins -> DESKTOP-CRLPVE5\<username> -> double click -> Server Roles -> check "public" and "sysadmin"
+    * SSMS -> Object explorer -> Security -> Logins -> DESKTOP-CRLPVE5\<username> -> double click -> Server Roles -> check "sysadmin"
+{{tag>["give access rights to users in microsoft sql server management studio"]}}