"Jonas" <jonas@nospam.pl> wrote in message
news:uTfZpn5sDHA.424@TK2MSFTNGP11.phx.gbl...
> Hi!
>
> I'm trying to get the NT group membership of a specified username from
TSQL.
> I'm using the following to query the OS:
>
> SELECT *
> FROM OPENROWSET(NetUserGetGroups, @NTUserName) AS NT
>
> It works fine except the fact that it seems that the result is cached
> somewhere, because if I run it once when a user is member of a certain
group
> it, and then remove the user from the group and rerun the statement, it
> still reports the user as a group member. Even if I remove the group
> altogether, it still lists the group.
>
> Any tips on this?
>
> Brgds
>
> Jonas
>
>

"Russell Fields" <RussellFields@NoMailPlease.Com> wrote in message
news:uYOIF15sDHA.2060@TK2MSFTNGP10.phx.gbl...
> Jonas,
>
> FWIW, changes to names on the domain take a few minutes to replicate
around.
> I am not a net admin, but I have run into this in the past. If you wait a
> few minutes are your results correct? (Takes as much as 15 minutes on the
> domain where I work.)
>
> Russell Fields
>
> "Jonas" <jonas@nospam.pl> wrote in message
> news:uTfZpn5sDHA.424@TK2MSFTNGP11.phx.gbl...
> > Hi!
> >
> > I'm trying to get the NT group membership of a specified username from
> TSQL.
> > I'm using the following to query the OS:
> >
> > SELECT *
> > FROM OPENROWSET(NetUserGetGroups, @NTUserName) AS NT
> >
> > It works fine except the fact that it seems that the result is cached
> > somewhere, because if I run it once when a user is member of a certain
> group
> > it, and then remove the user from the group and rerun the statement, it
> > still reports the user as a group member. Even if I remove the group
> > altogether, it still lists the group.
> >
> > Any tips on this?
> >
> > Brgds
> >
> > Jonas
> >
> >
>
>

"Jonas" <jonas@nospam.pl> wrote in message
news:%23Nlzq55sDHA.4060@TK2MSFTNGP11.phx.gbl...
> Thanks for your answer which sounds resonable, but the group I'm playing
> around with is a local group on my own computer, which should be available
> directly. If I run the NET LOCALGROUP, the changes are instantaneous.
>
> I think the "caching" takes places somewhere in the SQL Server, but I'm
not
> sure.
>
> Brgds
>
> Jonas
>
> "Russell Fields" <RussellFields@NoMailPlease.Com> wrote in message
> news:uYOIF15sDHA.2060@TK2MSFTNGP10.phx.gbl...
> > Jonas,
> >
> > FWIW, changes to names on the domain take a few minutes to replicate
> around.
> > I am not a net admin, but I have run into this in the past. If you wait
a
> > few minutes are your results correct? (Takes as much as 15 minutes on
the
> > domain where I work.)
> >
> > Russell Fields
> >
> > "Jonas" <jonas@nospam.pl> wrote in message
> > news:uTfZpn5sDHA.424@TK2MSFTNGP11.phx.gbl...
> > > Hi!
> > >
> > > I'm trying to get the NT group membership of a specified username from
> > TSQL.
> > > I'm using the following to query the OS:
> > >
> > > SELECT *
> > > FROM OPENROWSET(NetUserGetGroups, @NTUserName) AS NT
> > >
> > > It works fine except the fact that it seems that the result is cached
> > > somewhere, because if I run it once when a user is member of a certain
> > group
> > > it, and then remove the user from the group and rerun the statement,
it
> > > still reports the user as a group member. Even if I remove the group
> > > altogether, it still lists the group.
> > >
> > > Any tips on this?
> > >
> > > Brgds
> > >
> > > Jonas
> > >
> > >
> >
> >
>
>

"Jonas" <jonas@nospam.pl> wrote in message
news:eRH4rIEtDHA.2360@TK2MSFTNGP10.phx.gbl...
> Some more investigations has revealed that the time for a group membership
> change to appear when using this function is between a couple of minutes
up
> to almost ten minutes.
>
> /Jonas
>
> "Jonas" <jonas@nospam.pl> wrote in message
> news:%23Nlzq55sDHA.4060@TK2MSFTNGP11.phx.gbl...
> > Thanks for your answer which sounds resonable, but the group I'm playing
> > around with is a local group on my own computer, which should be
available
> > directly. If I run the NET LOCALGROUP, the changes are instantaneous.
> >
> > I think the "caching" takes places somewhere in the SQL Server, but I'm
> not
> > sure.
> >
> > Brgds
> >
> > Jonas
> >
> > "Russell Fields" <RussellFields@NoMailPlease.Com> wrote in message
> > news:uYOIF15sDHA.2060@TK2MSFTNGP10.phx.gbl...
> > > Jonas,
> > >
> > > FWIW, changes to names on the domain take a few minutes to replicate
> > around.
> > > I am not a net admin, but I have run into this in the past. If you
wait
> a
> > > few minutes are your results correct? (Takes as much as 15 minutes on
> the
> > > domain where I work.)
> > >
> > > Russell Fields
> > >
> > > "Jonas" <jonas@nospam.pl> wrote in message
> > > news:uTfZpn5sDHA.424@TK2MSFTNGP11.phx.gbl...
> > > > Hi!
> > > >
> > > > I'm trying to get the NT group membership of a specified username
from
> > > TSQL.
> > > > I'm using the following to query the OS:
> > > >
> > > > SELECT *
> > > > FROM OPENROWSET(NetUserGetGroups, @NTUserName) AS NT
> > > >
> > > > It works fine except the fact that it seems that the result is
cached
> > > > somewhere, because if I run it once when a user is member of a
certain
> > > group
> > > > it, and then remove the user from the group and rerun the statement,
> it
> > > > still reports the user as a group member. Even if I remove the group
> > > > altogether, it still lists the group.
> > > >
> > > > Any tips on this?
> > > >
> > > > Brgds
> > > >
> > > > Jonas
> > > >
> > > >
> > >
> > >
> >
> >
>
>