Re: Lost Permissions after Detach/Attach

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 06/28/04 

Date: Mon, 28 Jun 2004 13:44:37 +0100

Can't imagine how that can happen, in that case. Anyway, try the suggestion
from that article and see if it helps. 

-- 
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"DraguVaso" <pietercoucke@hotmail.com> wrote in message
news:u1$%236IQXEHA.3716@TK2MSFTNGP11.phx.gbl...
No, it was just form one partition to another on the same Server...
"Narayana Vyas Kondreddi" <answer_me@hotmail.com> wrote in message
news:%23HkCeOPXEHA.1764@TK2MSFTNGP10.phx.gbl...
> Did you move those databases to a different machine/different domain?
>
> See if this article helps:
> http://vyaskn.tripod.com/troubleshooting_orphan_users.htm
> -- 
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "DraguVaso" <pietercoucke@hotmail.com> wrote in message
> news:eWmHUIOXEHA.1152@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> I did a Detach and Attazch of some Databases to put them on another
> Harddisk. Afterwarths suddenly it seemed that a whole bunch of
Logins/Users
> lost there permissions on some Databases, one of theses Dataabses wasn't
> even been Detached.
>
> Does somebody knows what caused this problem? How to find a solution to
get
> all the persmissions back to what they were? And how to prevent this
problem
> in the future?
>
> Thanks, Pieter
>
>
>

Relevant Pages

  • Re: so slow DDQ update statement...
    ... Vyas, MVP (SQL Server) ... SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/ ... > Vyas, MVP ...
    (microsoft.public.sqlserver.dts)
  • Re: Stored procedure question
    ... Vyas, MVP (SQL Server) ... > where UserID = @UserID ... > Vyas, MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: delete a system sp
    ... Vyas, MVP (SQL Server) ... >> how to rename or delete a stored procedure .. ...
    (microsoft.public.sqlserver.security)
  • Re: Question about check contraints
    ... that CHECK constraint is looking for. ... Vyas, MVP (SQL Server) ... > Vyas, MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: hot backup
    ... the native Backup supplied by SQL Server will do. ... No need to go compression on such small databases. ... Mike Epprecht, Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
Loading