Monday, March 26, 2012

mobsync subs, security

Is there a trick to use mobsync at user level security? We have to set winxp
users to power user to allow the subscriptions to show up in sync manager...
Anyone know the individual folder/file permissions to set?
Thanks!
Scott Kramer
CDS Technologies, Inc.
www.clevelanddata.com
www.groundzerolan.com
www.team501.com
you restrict security to pull subscriptions in the pal at the account or
group level.
To do this right click on your publication and select publication properties
and go to the security tab. Enter the accounts or groups here.
Group membership is the way to administer large numbers of users.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"S c o t t K r a m e r" <sckramer2000@.hotmail.com> wrote in message
news:LOtQc.985$Nd7.61@.fe39.usenetserver.com...
> Is there a trick to use mobsync at user level security? We have to set
winxp
> users to power user to allow the subscriptions to show up in sync
manager...
> Anyone know the individual folder/file permissions to set?
> Thanks!
> --
> Scott Kramer
> CDS Technologies, Inc.
> www.clevelanddata.com
> www.groundzerolan.com
> www.team501.com
>
>
|||those are there, I mean the actual sync manager will not show the
subscription if the security level of the logged in winxp user is Users
(works of member of power users or administrators)
we want to lock these machines down (it replicated sales force db) & want to
avoid users being power users +...
-- Original Message --
From: "Hilary Cotter" <hilaryk@.att.net>
Newsgroups: microsoft.public.sqlserver.replication
Sent: Thursday, August 05, 2004 1:50 PM
Subject: Re: mobsync subs, security

> you restrict security to pull subscriptions in the pal at the account or
> group level.
> To do this right click on your publication and select publication
properties
> and go to the security tab. Enter the accounts or groups here.
> Group membership is the way to administer large numbers of users.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "S c o t t K r a m e r" <sckramer2000@.hotmail.com> wrote in message
> news:LOtQc.985$Nd7.61@.fe39.usenetserver.com...
> winxp
> manager...
>
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:#82QDUxeEHA.556@.tk2msftngp13.phx.gbl...
> you restrict security to pull subscriptions in the pal at the account or
> group level.
> To do this right click on your publication and select publication
properties
> and go to the security tab. Enter the accounts or groups here.
> Group membership is the way to administer large numbers of users.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "S c o t t K r a m e r" <sckramer2000@.hotmail.com> wrote in message
> news:LOtQc.985$Nd7.61@.fe39.usenetserver.com...
> winxp
> manager...
>
|||what happens if you add the users to the local service group?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"S c o t t K r a m e r" <sckramer2000@.hotmail.com> wrote in message
news:VpwQc.1882$Nd7.684@.fe39.usenetserver.com...
> those are there, I mean the actual sync manager will not show the
> subscription if the security level of the logged in winxp user is Users
> (works of member of power users or administrators)
> we want to lock these machines down (it replicated sales force db) & want
to
> avoid users being power users +...
> -- Original Message --
> From: "Hilary Cotter" <hilaryk@.att.net>
> Newsgroups: microsoft.public.sqlserver.replication
> Sent: Thursday, August 05, 2004 1:50 PM
> Subject: Re: mobsync subs, security
>
> properties
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:#82QDUxeEHA.556@.tk2msftngp13.phx.gbl...
> properties
>
>
|||how do you do that in xp? I do not see that group--? I'm using compmgmt.msc
(not the dumbed down interface)--
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:uC$fu8GfEHA.2896@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> what happens if you add the users to the local service group?
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "S c o t t K r a m e r" <sckramer2000@.hotmail.com> wrote in message
> news:VpwQc.1882$Nd7.684@.fe39.usenetserver.com...
want[vbcol=seagreen]
> to
or[vbcol=seagreen]
set[vbcol=seagreen]
or[vbcol=seagreen]
set
>
|||In Groups, double click on the group. Click Add, double click service, OK,
Apply, and OK.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"S c o t t K r a m e r" <sckramer2000@.hotmail.com> wrote in message
news:RTNRc.1877$vn3.478@.fe39.usenetserver.com...
> how do you do that in xp? I do not see that group--? I'm using
compmgmt.msc[vbcol=seagreen]
> (not the dumbed down interface)--
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:uC$fu8GfEHA.2896@.TK2MSFTNGP11.phx.gbl...
Users[vbcol=seagreen]
> want
account[vbcol=seagreen]
> or
> set
account
> or
> set
>
>
|||hmmm, ok, tried service & local service, subs still dont show
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:eodYGIjfEHA.140@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> In Groups, double click on the group. Click Add, double click service, OK,
> Apply, and OK.
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "S c o t t K r a m e r" <sckramer2000@.hotmail.com> wrote in message
> news:RTNRc.1877$vn3.478@.fe39.usenetserver.com...
> compmgmt.msc
> Users
> account
message[vbcol=seagreen]
to[vbcol=seagreen]
sync[vbcol=seagreen]
> account
message[vbcol=seagreen]
to[vbcol=seagreen]
sync
>
|||I'm a little confused. Are you saying you open up mobsync, and don't see any
subscriptions listed to pull?
If they don't show up here, are they local, ie on the local machine?
What happens if you click on the "To select a subscription select this and
then click properties" and then enter the publication and subscription stuff
manually?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"S c o t t K r a m e r" <sckramer2000@.hotmail.com> wrote in message
news:d4PRc.2031$vn3.1760@.fe39.usenetserver.com...[vbcol=seagreen]
> hmmm, ok, tried service & local service, subs still dont show
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:eodYGIjfEHA.140@.TK2MSFTNGP12.phx.gbl...
OK,[vbcol=seagreen]
&[vbcol=seagreen]
publication[vbcol=seagreen]
users.[vbcol=seagreen]
> message
have[vbcol=seagreen]
> to
> sync
publication[vbcol=seagreen]
users.[vbcol=seagreen]
> message
have
> to
> sync
>
>
|||error writing to registry
"Hilary Cotter" <hilaryk@.att.net> wrote in message
news:uO6Rg0jfEHA.2604@.TK2MSFTNGP10.phx.gbl...
> I'm a little confused. Are you saying you open up mobsync, and don't see
any
> subscriptions listed to pull?
> If they don't show up here, are they local, ie on the local machine?
> What happens if you click on the "To select a subscription select this
and
> then click properties" and then enter the publication and subscription
stuff[vbcol=seagreen]
> manually?
> --
> Hilary Cotter
> Looking for a book on SQL Server replication?
> http://www.nwsu.com/0974973602.html
>
> "S c o t t K r a m e r" <sckramer2000@.hotmail.com> wrote in message
> news:d4PRc.2031$vn3.1760@.fe39.usenetserver.com...
> OK,
message[vbcol=seagreen]
the[vbcol=seagreen]
is[vbcol=seagreen]
db)
> &
> publication
> users.
> have
> publication
> users.
> have
>
|||use regedt32 to grant everyone access to this key
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\80\Replication\Subscriptions
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"S c o t t K r a m e r" <sckramer2000@.hotmail.com> wrote in message
news:I66Sc.1470$Tn6.1330@.fe39.usenetserver.com...[vbcol=seagreen]
> error writing to registry
>
> "Hilary Cotter" <hilaryk@.att.net> wrote in message
> news:uO6Rg0jfEHA.2604@.TK2MSFTNGP10.phx.gbl...
> any
> and
> stuff
service,[vbcol=seagreen]
> message
> the
> is
> db)
the[vbcol=seagreen]
here.[vbcol=seagreen]
in[vbcol=seagreen]
set?[vbcol=seagreen]
the[vbcol=seagreen]
here.[vbcol=seagreen]
in[vbcol=seagreen]
set?
>
>

No comments:

Post a Comment