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 Solt

.

Relevant Pages

  • Re: Pipe Delimited files with headers
    ... but if you're happy with scripting and text ... Here's a sample VBScript that shifts data from a text file into a table ... 'a table in an MDB database without opening Access ... Dim oTDef 'As DAO.TableDef ...
    (microsoft.public.access.externaldata)
  • why should i use tcl?
    ... i'd like to ask about tcl. ... while database and communication may be left common to all ... this requirement makes the use of embeddable scripting language the best ... the sripting language i'd like to use should fit some requirements. ...
    (comp.lang.tcl)
  • Re: need to do a domain inventory, but cant afford SMS
    ... > inventory of all the equipment. ... For inventory to a csv file using WMI from vbscript (WMI comes default with ... The acquired information is written to a database using ADO." ... Microsoft MVP Scripting and WMI, ...
    (microsoft.public.win2000.general)
  • Re: IsValid(Object)
    ... It's a scripting language that I'm building, ... database might have been wiped. ... work in a strict order because it's a series of scripting commands. ...
    (borland.public.delphi.language.objectpascal)
  • Re: List of Duplicate Users in a Forest
    ... A database and some scripting would be useful. ... > Directory forest with about eight domains. ... > cleanup process until the users have migrated into AD. ...
    (microsoft.public.windows.server.active_directory)