Role for alowing replication

Hello there
If i need to replicate two servers that i don't want that the subsriber user
won't be member of sysadmin and db_owner.
Which role i need to declare in order to allow transactional replication?
' 03-5611606
' 050-7709399
: roy@.atidsm.co.il
For push IIRC it needs to be in the ddl_admin role (as it needs to create
tables), and data_reader, data_writer.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23qA5HisFGHA.1312@.TK2MSFTNGP09.phx.gbl...
> Hello there
> If i need to replicate two servers that i don't want that the subsriber
> user won't be member of sysadmin and db_owner.
> Which role i need to declare in order to allow transactional replication?
> --
>
> ' 03-5611606
> ' 050-7709399
> : roy@.atidsm.co.il
>
|||Whell Hilary
On the current computer who have problem none of the servers rols are active
The user i'm use to access the other computer has access only to this
database, and it is members of db_public, db_ddladmin, db_datawriter,
db_datareader
And it still cause problems
' 03-5611606
' 050-7709399
: roy@.atidsm.co.il
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OqtwqRuFGHA.3036@.tk2msftngp13.phx.gbl...
> For push IIRC it needs to be in the ddl_admin role (as it needs to create
> tables), and data_reader, data_writer.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:%23qA5HisFGHA.1312@.TK2MSFTNGP09.phx.gbl...
>