Retrieve SQL Server 2000 rights for a user

  • Thread starter Thread starter Robert Wehofer
  • Start date Start date
R

Robert Wehofer

Hello there!

How is it possible to find out whether a certain user has got owner rights
in a certain SQL Server 2000 database by using ADO.NET?

Robert
 
If you are willing to query the master database, you can find out anything
you wish. The downside is you end up potentially opening the master database
to hacks. You can reduce the danger by writing stored procedures, but
remember the account you use has at least some master database access.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
 
Back
Top