delete all users from database and set one user
-
i want to know how can i delete (or disable) all users (dbo, guest, etc.) from my database and set one user for my database. in fact i don't want other users could to connect to mydatabase in any sql server.
hi Use enter prise Manager To remove Users ..Follow these steps 1)To remove a user account from a database role 2)Expand a server group, and then expand a server. 3)Expand Databases, and then expand the database in which the role exists. 4)Click Roles. 5)In the details pane, right-click the role to which the user account belongs, and then click Properties. 6)Select the user to remove, and then click Remove.
-
hi Use enter prise Manager To remove Users ..Follow these steps 1)To remove a user account from a database role 2)Expand a server group, and then expand a server. 3)Expand Databases, and then expand the database in which the role exists. 4)Click Roles. 5)In the details pane, right-click the role to which the user account belongs, and then click Properties. 6)Select the user to remove, and then click Remove.
thank you, so i will remove all users (dbo, ..) from my database and set one user to it and detach it from sql server, now i have a mdf file that just one user could connect to it. let me know in any machine with sql server express just my user could connect to it and others (dbo, ...) could not connect to my database? in fact i don't want any user from any machine could connect or view my database.