Results 1 to 2 of 2

Thread: SID importance

  1. 03-12-2001, 06:27 PM #1
    Kri Guest

    SID importance

    Hi,
    I am using Sql 7.0 with sp2. I just started as a sql dba. I have a question here, What is the importance of SID's ? When we are mapping to sql logins and user_id 's how we have to give importance regarding SID's.
    Pls suggest me a good article or some suggestions...

    Thanks!
    Reply With Quote Reply With Quote
  2. 03-13-2001, 02:19 AM #2
    Dale Shaw Guest

    SID importance (reply)

    Whenever you create any security in NT (including SQL using NT authenication) you are granting permissions to the user via it's SID, not the user name. To test this try:

    use master
    select * from syslogins

    If you give login permissions to a certain user via NT then delete and recreate the user (same name) they will not have access. This is the same behaviour as NT.

    Hope this answers you question ...

    Dale


    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules