Re: Remove all permission restrictions

Steve
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@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:1160671910.190428.264470@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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



.