Q
Problem solve Get help with specific problems with your technologies, process and projects.

Script to show permissions

I am trying to write a script for SQL Server 2000 that will show me permissions down to the column level. I think I understand that this information can be found in the syspermissions table (linked to sysobjects, syscolumns, and sysusers). However, a number of these columns are bitmaps, and I have not been able to find out how to write the decode bitmap so I can link to syscolumns to see which particular columns are referenced. Would you be able to provide some information on this? My purpose is twofold: 1) Be able to run this query so I can see the details (which Enterprise Manager provides visually) and 2) Use this information to be able to copy security from one DB instance to another on same or different server.
Sure. Open Profiler. Point it at the server. Open Enterprise Manager. View the security information. Stop the Profiler trace. Look in the output for the command that Enterprise Manager sends to retrieve the security information.

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close