Environment users and logins

Hi
We are currently migrating from MSSQL 2000 enterprice to MSSQL 2005
Enterprice, and with that doing a revision of our users.
We would like to be able to do a restore a backup of Production to test.
We would like user privileges on the servers to differ so a given user can
execute some stored procedures on one environment but not the other. Say, we
don’t want a service in test with the wrong connection string to be have
access to production.
We have previously done this by using local user groups on the servers, but
we loose the mapping between the Login name and the user name when we do the
restores.
Any ideas or best practices?
Best regards
MikaelMikael
> We would like to be able to do a restore a backup of Production to test.
No problem, just RESTORE command

> We would like user privileges on the servers to differ so a given user can
> execute some stored procedures on one environment but not the other. Say,
> we
> dont want a service in test with the wrong connection string to be have
> access to production.
MS has introduced in SS2005 lots of new features, like SCHEMA for example.
I'd suggets you to spend a hew days to study it

> We have previously done this by using local user groups on the servers,
> but
> we loose the mapping between the Login name and the user name when we do
> the
> restores.
http://blogs.msdn.com/lcris/archive.../03/567680.aspx
"Mikael" <Mikael@.discussions.microsoft.com> wrote in message
news:48261D3D-86AC-4B6F-8B0A-380101564866@.microsoft.com...
> Hi
> We are currently migrating from MSSQL 2000 enterprice to MSSQL 2005
> Enterprice, and with that doing a revision of our users.
> We would like to be able to do a restore a backup of Production to test.
> We would like user privileges on the servers to differ so a given user can
> execute some stored procedures on one environment but not the other. Say,
> we
> dont want a service in test with the wrong connection string to be have
> access to production.
> We have previously done this by using local user groups on the servers,
> but
> we loose the mapping between the Login name and the user name when we do
> the
> restores.
> Any ideas or best practices?
>
> --
> Best regards
> Mikael

Enterprice manager.

Hi there.
When i allow remote connection to my sql with Enterprice Manager .. users
see
the list of all databases but can only enter there own .
How can i make it so, so they only see there own database witch there user
has
access to ?
Regards.
Steinarr.Hi,
This is not possible in SQL 7.0 and SQL 2000.
Thanks
Hari
SQL Server MVP
"Steinarr G." <steinki@.dynamicsystems.dk> wrote in message
news:eH$JN3JrFHA.3264@.TK2MSFTNGP12.phx.gbl...
> Hi there.
> When i allow remote connection to my sql with Enterprice Manager .. users
> see
> the list of all databases but can only enter there own .
> How can i make it so, so they only see there own database witch there user
> has
> access to ?
> Regards.
> Steinarr.
>|||Thanks Hari.
Now at least i know it for sure.
Regards.
Steinarr.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ueE%2364JrFHA.716@.TK2MSFTNGP10.phx.gbl...
> Hi,
> This is not possible in SQL 7.0 and SQL 2000.
> Thanks
> Hari
> SQL Server MVP
> "Steinarr G." <steinki@.dynamicsystems.dk> wrote in message
> news:eH$JN3JrFHA.3264@.TK2MSFTNGP12.phx.gbl...
>