I'm creating a fitness management project with multiple SQL Server logins and users. I was successful in creating new logins and it's user using vb.net but now I'm facing an issue with dropping unnecessary logins and users.
Can anyone help me with this issue? Thank you in advance
What I used:
Connection string: fitnessdb
SqlCommand("Drop user ['"& user_name &"']"
Connection string: master
Sqlcommand("Drop login['"&user_name&"']"
I get this exception:
Cannot drop user because it does not exist or you don not have permission