Re: SQL SERVER 2000: obtain user list
- From: diaboliko80@xxxxxxxxx
- Date: 18 Jan 2007 23:57:46 -0800
Ok, thanks but I don't understand what to use SQL PROFILER to obtain
the complete list of the user's permission...
Are you sure?
Steve ha scritto:
diaboliko80@xxxxxxxxx wrote:
Hi,The tool in SQL Server is Profiler.
I would like extract in a document (.doc, .txt, .cvs, .xml or also) the
complete list of all user that logins to my SqlServer 2000.... that is
I need to know for each user to which databases accedes.
For example, the user TOM WHITE accedes to the database [SCHOOL],
[NEWS] and [JOB] with read/write permissions. I would like extract
these informations for all user and prints in a file to obtain a
complete documentation dinamically.
It's possible in SqlServer2000?
Thanks,
Luigi.
PS: sorry, but I don't write English very well.. :_(
See the Books Online topic "Introducing SQL Server Profiler "
or on the web http://msdn2.microsoft.com/en-us/library/ms181091.aspx
.
- References:
- SQL SERVER 2000: obtain user list
- From: diaboliko80
- Re: SQL SERVER 2000: obtain user list
- From: Steve
- SQL SERVER 2000: obtain user list
- Prev by Date: Re: Rather urgent: Cannot open user default database. Login failed.
- Next by Date: Visual Basic 6.0 + SQL Server 2005, OK ?
- Previous by thread: Re: SQL SERVER 2000: obtain user list
- Next by thread: Cannot Install SQL Server 2005 Dev edition
- Index(es):
Relevant Pages
|
|
