Re: Environment users and logins

Mikael
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
don?t 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/2006/04/03/567680.aspx

"Mikael" <Mikael@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:48261D3D-86AC-4B6F-8B0A-380101564866@xxxxxxxxxxxxxxxx
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

Mikael


.

Relevant Pages

  • Re: winlogin.exe and viruses
    ... Enquire, plan and execute. ... Please tell the newsgroup how any ... Turn off System Restore until cleaning is ... just a desktop folder). ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: System Restore will not work? (It IS enabled)
    ... Enquire, plan and execute ... Try using an earlier restore point in safe mode. ...
    (microsoft.public.windowsxp.perform_maintain)
  • help recovering from stupid rm trick
    ... In my haste to use my command history to execute a command, ... as root, from the root directory. ... to restore most of the linux tools. ...
    (comp.unix.aix)
  • Re: unable to system restore
    ... Enquire, plan and execute ... I just disabled Norton and was able to restore to thursday, ... to use System Restore to go back to an earlier point in time. ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: Access 2003 and null vs. 0
    ... you receive no indication that the query failed to execute. ... If you use the AfterUpdate event of the form, ... Or if they changed the product, do you restore the quantity of the ... do you restore the deleted quantities for each product? ...
    (microsoft.public.access.formscoding)