Re: Using script to list users and their allocated security
From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 02/15/05
- Next message: Dan D.: "allowing outside party to access database"
- Previous message: Wayne Snyder: "Re: Using script to list users and their allocated security"
- In reply to: Andrewb: "Using script to list users and their allocated security"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Feb 2005 09:25:36 -0500
Now that I think about it, I doubt the views include permissions obtained
via system roles, (but I do not know)... So check that out as well..
-- Wayne Snyder, MCDBA, SQL Server MVP Mariner, Charlotte, NC www.mariner-usa.com (Please respond only to the newsgroups.) I support the Professional Association of SQL Server (PASS) and it's community of SQL Server professionals. www.sqlpass.org "Andrewb" <Andrewb@discussions.microsoft.com> wrote in message news:88D81F5A-7433-408A-8E9A-07523B3D8202@microsoft.com... > If you are reading this for a second time my apologies.I consider this to > be > both general and a security issue. > > Is the question in the tilte possible? I am trying to select users/logins > in > a SQL Server 2000 database with read permissions or write permissions via > writng sql script. > > I want to use asp to restrict functionality based on read write database > access to only certain users without using logging in pages and a another > table but to be recognised simply from their network log in. > >
- Next message: Dan D.: "allowing outside party to access database"
- Previous message: Wayne Snyder: "Re: Using script to list users and their allocated security"
- In reply to: Andrewb: "Using script to list users and their allocated security"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
