Hi knights,
Pls show me the way to prevent the other users seeing all logins when they logon into SQL Server. Thnks in advance!You can set permissions on master..sylogins view and master..sysxlogins.
There may be a procedure just like if we wanna restrict a user to change password using sp_password.
Tamperring with system tables is not a good idea though. Folks may have better options, wait for them.
Howdy.|||See if this (http://www.sqlservercentral.com/columnists/rmarda/letsblockthedba_printversion.asp) can give you some ideas. But why do you need to "hide" logins? Are passwords too easy to guess? Maybe that's what you need to address, hey?!
No comments:
Post a Comment