RE: help! report users permission on a SQL 2000 server
From: Fany Vargas (fanyv_at_microsoft.com)
Date: 11/19/04
- Next message: Stan Kasper: "DisallowAdhocAccess or DisallowAdHocAccess ?"
- Previous message: Kevin McDonnell [MSFT]: "Re: Event ID: 17055 Source: MSSQLSERVER Type: Information Login failed"
- In reply to: Wen Ou: "help! report users permission on a SQL 2000 server"
- Next in thread: Wen Ou: "RE: help! report users permission on a SQL 2000 server"
- Reply: Wen Ou: "RE: help! report users permission on a SQL 2000 server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 19 Nov 2004 08:48:39 GMT
You can use sp_helprotect, it is ran as follows:
use db1
sp_helprotect @username = 'Username'
use db2
sp_helprotect @username = 'Username'
- Next message: Stan Kasper: "DisallowAdhocAccess or DisallowAdHocAccess ?"
- Previous message: Kevin McDonnell [MSFT]: "Re: Event ID: 17055 Source: MSSQLSERVER Type: Information Login failed"
- In reply to: Wen Ou: "help! report users permission on a SQL 2000 server"
- Next in thread: Wen Ou: "RE: help! report users permission on a SQL 2000 server"
- Reply: Wen Ou: "RE: help! report users permission on a SQL 2000 server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
