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!
**********************************************************************
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot display ODBC login prompt - want to connect without DSN 31
What are the steps to fix damaged MDF files in SQL Server? 0
How to retrieve a returned SQL function value? 1
Dinamically retrieve existing relations in a database 0
SQL Server 2000 9
Asynchronous access to database using ADO.NET 1.1 1
SQL Server 2005 and ADO.NET 1.1? 3
Sql Server Express won't let me connect 8

Back
Top