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
>

Remote non-administrator monitoring of sql stats

How can I get my sql dba's to access sql counters in performance monitor
without making them computer administrators? Q158438 has aided them in
busting them into all the standard counters, but still, only my computer
administrator account seems to be able to find the sql counters?hmm... didn't know about that KB. Interesting...
In the past I've told DBA's they can look at SQL specific counters by
reading master..sysperfinfo directly. That's where PerfMon grabs all it's
SQL data from...
you could always query the table directly...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Robert Hindla" <rhindla@.panix.com> wrote in message
news:BB31AFED.5B2B%rhindla@.panix.com...
> How can I get my sql dba's to access sql counters in performance monitor
> without making them computer administrators? Q158438 has aided them in
> busting them into all the standard counters, but still, only my computer
> administrator account seems to be able to find the sql counters?
>