Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2007

    Unanswered: Which of the two or more users' privileges?

    I am very new to the SQL database. I have the following query. I would appreciate if someone could clarify this for me:

    I have created two users (user1 & user2) under the same login name test1 in SQL Server 2005 Database. Further I used the login name (test1) & password (******) of SQL Server in connection string to connect to database.

    Now I want to know that how & where can I refer the user name (user1 or user2) to use its previliges.

    How will I know that which user's privileges level is used in the connection.?

  2. #2
    Join Date
    May 2003
    Rochester, NY
    ...I guess my first question would be why would you create two userids within the same database from the same login? I'm not sure what you are trying to accomplish in doing this.

Posting Permissions

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