Add users to logshipping database on secondary server

Hi Folks,
I need to add new read only users to our databases on seconday server of
logshipping.
As all those db's are readonly, How can I add users to it?
It is on sql 2000 sp3
Please help.
Kumar> As all those db's are readonly, How can I add users to it?
You can't. You can't do anything inside a log shipped or mirror database. So this has to be
performed in the source database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kumar" <Kumar@.discussions.microsoft.com> wrote in message
news:61086CE0-9F44-495B-AEBC-F8D8E9BBCD48@.microsoft.com...
> Hi Folks,
> I need to add new read only users to our databases on seconday server of
> logshipping.
> As all those db's are readonly, How can I add users to it?
> It is on sql 2000 sp3
> Please help.
> Kumar

Add users to logshipping database on secondary server

Hi Folks,
I need to add new read only users to our databases on seconday server of
logshipping.
As all those db's are readonly, How can I add users to it?
It is on sql 2000 sp3
Please help.
Kumar
> As all those db's are readonly, How can I add users to it?
You can't. You can't do anything inside a log shipped or mirror database. So this has to be
performed in the source database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kumar" <Kumar@.discussions.microsoft.com> wrote in message
news:61086CE0-9F44-495B-AEBC-F8D8E9BBCD48@.microsoft.com...
> Hi Folks,
> I need to add new read only users to our databases on seconday server of
> logshipping.
> As all those db's are readonly, How can I add users to it?
> It is on sql 2000 sp3
> Please help.
> Kumar

Add users to logshipping database on secondary server

Hi Folks,
I need to add new read only users to our databases on seconday server of
logshipping.
As all those db's are readonly, How can I add users to it?
It is on sql 2000 sp3
Please help.
Kumar> As all those db's are readonly, How can I add users to it?
You can't. You can't do anything inside a log shipped or mirror database. So
this has to be
performed in the source database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kumar" <Kumar@.discussions.microsoft.com> wrote in message
news:61086CE0-9F44-495B-AEBC-F8D8E9BBCD48@.microsoft.com...
> Hi Folks,
> I need to add new read only users to our databases on seconday server of
> logshipping.
> As all those db's are readonly, How can I add users to it?
> It is on sql 2000 sp3
> Please help.
> Kumar