Documenting Permissions on SQL Server 7.0 and 2000

http://support.microsoft.com/default.aspx?scid=kb;en-us;179158&Product=sq
I found the above article which shows a stored procedure for SQL Server 6.5 which documents all permissions for a particular Database
Is there a way to document permissions on SQL Server 7 and 2000 instances?
Thank you in advancewhat is wrong with exec sp_helprotect (sql 2000).
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Janice Potucek" <janice.potucek@.nextiraone.com> wrote in message
news:89BABFBC-3EC8-4D17-BB3D-51DF05A7820E@.microsoft.com...
> http://support.microsoft.com/default.aspx?scid=kb;en-us;179158&Product=sql
> I found the above article which shows a stored procedure for SQL Server
6.5 which documents all permissions for a particular Database.
> Is there a way to document permissions on SQL Server 7 and 2000
instances?
> Thank you in advance|||Thank you. That was what I was looking for!!!!
I have been trying different combinations of parameters ... what I
would like to see is only the default database, Server Roles and
Database access permissions for a particular user. Is there a way to
get only that information? It is very tedious documenting this
manually.
Thank you in advance,
J Potucek
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Documenter

In Access you can analyze tables and use the documenter to
write out all of the tables with their permissions, column
names, data types etc. Is there a way to do this in SQL
Server?Hi Tammy
SQL 2000 and earlier does not have a tool like Access documentor.
You can run sp_help with a table name as a parameter and view the same
information. Information Schema Views might also be used to build your own.
If you want to save a copy of the scripts used to rebuild your objects, you
can script all the objects in a SQL Server database. (Right click on the
database, All Tasks, Generate SQL Script...)
Nick Schueler
| Content-Class: urn:content-classes:message
| From: "tammy" <tammy@.urban.csuohio.edu>
| Sender: "tammy" <tammy@.urban.csuohio.edu>
| Subject: Documenter
| Date: Fri, 20 Feb 2004 07:30:18 -0800
| Lines: 4
| Message-ID: <1310201c3f7c6$71e90df0$a101280a@.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcP3xnHpbT3GZ9OEQZKEzULTHYNYMg==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.sqlserver.datawarehouse
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.datawarehouse:18909
| NNTP-Posting-Host: tk2msftngxa09.phx.gbl 10.40.1.161
| X-Tomcat-NG: microsoft.public.sqlserver.datawarehouse
|
| In Access you can analyze tables and use the documenter to
| write out all of the tables with their permissions, column
| names, data types etc. Is there a way to do this in SQL
| Server?
|