Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Posts
    14

    Unanswered: How can get Users authorization benefits.

    Hi Friends,

    I am new to MS SQL Server.
    I am working on MS SQL Server Login and Users creation.

    My doubt is if I am creating two users mapped with the one and same login and I am authorizing 1st user on first few tables and 2nd user with rest of the tables then how I will be benefitted of creating users where I am logging in with the log in name? If those users are loging in with login name then how the benefit of rights restriction will get?

    Please help on this...

    Regards,
    Ashish

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I just added a section to the DBForums SQL Server FAQ for this topic. This type of question comes up often enough that it belongs in the FAQ to make it easier for people to find the answer.

    -PatP

  3. #3
    Join Date
    Sep 2008
    Posts
    14

    Security: User in SQL server

    Thnaks Pat .

    Regards,
    Ashish

Posting Permissions

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