Re: Windows Group in SQL Login
From: Denny (mrdenny_at_gamespy.com)
Date: 04/28/03
- Next message: Michael Fong: "How do I let users create databases and only let them delete their own?"
- Previous message: Andrew J. Kelly: "Re: Linked Server login problem with a Job"
- In reply to: TNL: "Re: Windows Group in SQL Login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 28 Apr 2003 13:25:45 -0700
So you granted it the roll public, and that it? Then assigned the roll
permissions on each specific table?
-- Denny Cherry Database Administrator GameSpy Industries "TNL" <le.nhan@freenet.de> wrote in message news:%23%2338M6fCDHA.2296@TK2MSFTNGP10.phx.gbl... > Only the permission to access the Database "myDatabase". This group doesn't > have any SQL Server roles. > Thanks > > "Denny" <mrdenny@gamespy.com> schrieb im Newsbeitrag > news:e0#UNfcCDHA.2316@TK2MSFTNGP10.phx.gbl... > > what permissions did you grant the group "TEST"? > > > > -- > > Denny Cherry > > Database Administrator > > GameSpy Industries > > > > > > "news.microsoft.com" <le.nhan@freenet.de> wrote in message > > news:#M4L3qbCDHA.972@TK2MSFTNGP11.phx.gbl... > > > I am trying to grant permissions to a Windows 2000 group "TEST" (not > > builtin > > > group), this group can access the Database "myDatabase". The user > "user1" > > is > > > a member of the group "TEST". > > > > > > But I can not login in the Database with the user "user1" (when the > user1 > > is > > > the active windows user). > > > > > > Where is the problem? > > > > > > TNL > > > > > > > > > > > >
- Next message: Michael Fong: "How do I let users create databases and only let them delete their own?"
- Previous message: Andrew J. Kelly: "Re: Linked Server login problem with a Job"
- In reply to: TNL: "Re: Windows Group in SQL Login"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
