SQLTeam.com | Weblogs | Forums

SQL Login


#1

I have created one test login and give the access to one database, now when I have logged in from that id user has the option to change the password of SA via security tab, please suggest hot can I remove that tab


#2

In SSMS object explorer, expand the Security -> Logins node, right click on the login, properties and in Server Roles uncheck permissions that you don't need. Typically you should grant only public role to a regular user, and then grant them permissions on specific databases and database objects that they need.


#3

Hi buddy check this useful resources

http://ss64.com/sql/login_c.html

https://www.mindstick.com/blog/401/create-user-login-in-sql-server-2008-r2