Results 1 to 3 of 3

Thread: Hide logins:-)

  1. #1
    Join Date
    Nov 2002
    Posts
    19

    Thumbs up Unanswered: Hide logins:-)

    Hi knights,

    Pls show me the way to prevent the other users seeing all logins when they logon into SQL Server. Thnks in advance!

  2. #2
    Join Date
    Feb 2004
    Location
    PAKISTAN
    Posts
    106
    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.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    See if this 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?!
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •