Remove all permission restrictions

I have a site where my client attempted to change a lot of
authenticated users and I helped (aided and abetted?) him by scripting
over the previouls permissions. We are having a lot of problems now and
want to get back to a completely public editable and open database
before replanning roles and users and restricting rights.
To further complicate the issue, this database is a publisher and
although we have generated a snapshot, we haven't deployed it until
this is fixed - we don't want two sites where users can't see or edit
the data!
I would like to know the simplest way to make the database owned by
dbo, strip all non system users and roles, and to be able to make NT
Authority/Authenticated Users members of the dbowner role.
Thanks
Steve SoltSteve
> I would like to know the simplest way to make the database owned by
> dbo, strip all non system users and roles, and to be able to make NT
> Authority/Authenticated Users members of the dbowner role.
>
Take a look at sp_changedbowner system stored procedure
<s.solt@.czwgarchitects.co.uk> wrote in message
news:1160671910.190428.264470@.h48g2000cwc.googlegroups.com...
>I have a site where my client attempted to change a lot of
> authenticated users and I helped (aided and abetted?) him by scripting
> over the previouls permissions. We are having a lot of problems now and
> want to get back to a completely public editable and open database
> before replanning roles and users and restricting rights.
> To further complicate the issue, this database is a publisher and
> although we have generated a snapshot, we haven't deployed it until
> this is fixed - we don't want two sites where users can't see or edit
> the data!
> I would like to know the simplest way to make the database owned by
> dbo, strip all non system users and roles, and to be able to make NT
> Authority/Authenticated Users members of the dbowner role.
> Thanks
> Steve Solt
>