all groups > sql server replication > august 2004 >
You're in the

sql server replication

group:

mobsync subs, security


mobsync subs, security S c o t t K r a m e r
8/5/2004 1:06:08 PM
sql server replication:
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


Re: mobsync subs, security Hilary Cotter
8/5/2004 1:50:29 PM
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


[quoted text, click to view]

Re: mobsync subs, security S c o t t K r a m e r
8/5/2004 4:04:01 PM
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


[quoted text, click to view]


Re: mobsync subs, security Hilary Cotter
8/7/2004 7:10:51 AM
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


[quoted text, click to view]

Re: mobsync subs, security S c o t t K r a m e r
8/9/2004 12:46:41 PM
how do you do that in xp? I do not see that group--? I'm using compmgmt.msc
(not the dumbed down interface)--

[quoted text, click to view]


Re: mobsync subs, security Hilary Cotter
8/9/2004 12:55:39 PM
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


[quoted text, click to view]

Re: mobsync subs, security S c o t t K r a m e r
8/9/2004 2:08:07 PM
hmmm, ok, tried service & local service, subs still dont show :(

[quoted text, click to view]


Re: mobsync subs, security Hilary Cotter
8/9/2004 2:15:08 PM
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


[quoted text, click to view]

Re: mobsync subs, security S c o t t K r a m e r
8/10/2004 11:47:53 AM
error writing to registry


[quoted text, click to view]


Re: mobsync subs, security Hilary Cotter
8/10/2004 12:01:34 PM
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


[quoted text, click to view]

Re: mobsync subs, security S c o t t K r a m e r
8/10/2004 5:48:22 PM
cool!

specific permissions were allow: set value; create subkey...

Thanks!!!

[quoted text, click to view]
Re: mobsync subs, security S c o t t K r a m e r
8/10/2004 9:27:55 PM
have a nice secure sys now!

still can still delete subs adding those 2 allows tho!! aargh!!! At least
the rest of the system well stay clean! Those sales reps love to install
things they shouldn't... viruses & spyware also can't install themselves
nearly as easily at the user security level---

Thanks again!

[quoted text, click to view]
Re: mobsync subs, security Hilary Cotter
8/11/2004 10:54:17 AM
sorry Scott, I'm a little slow at times - exactly what does "still can still
delete subs adding those 2 allows tho!! aargh!!! " mean.

you can always use the replication activeX controls to pull the
subcsription, although they don't offer the functionality of WSM/mobsync.
Under the covers this is what mobsync/WSM uses.

--
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html


[quoted text, click to view]
AddThis Social Bookmark Button