RE: help! report users permission on a SQL 2000 server

From: Wen Ou (WenOu_at_discussions.microsoft.com)
Date: 11/23/04 

Date: Mon, 22 Nov 2004 19:31:02 -0800

thank you

I have another question. If a domain user belongs to a domain user group, is
it possible to find if this user get permissions to execute a stored
procedure? At the moment, the stored procedure i wrote only shows the
permisssion of user groups or independent users. what system stored
procedure can I use?

million thanks in adv

wen ou

"Fany Vargas [MSFT]" wrote:

> If you need to get this info for each database then you will indeed need to
> loop through each database. So using a cursor to loop through each database
> is a good option.
>
> Fany Vargas
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.
>
> Microsoft highly recommends that users with Internet access update their
> Microsoft software to better protect against viruses and security
> vulnerabilities. The easiest way to do this is to visit the following
> websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>

Relevant Pages

  • RE: Finding all Permissions for User or Group
    ... to have a tool to know what permissions a domain user has. ... You can post you inquire in the Developer newsgroups to do ... Microsoft can make no representation concerning the content of these sites. ... Finding all Permissions for User or Group ...
    (microsoft.public.windows.server.sbs)
  • Re: Folder Permissions
    ... Create a folder on SBS. ... In the Properties window of this folder, click Sharing tab, Permissions ... In the every domain user account's folder properties window, ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: SHAREPOINT AND RWW ISSUES
    ... In WSS 2.0, when you create a Domain User account, the server adds it to SharePoint with 'Web Designer' rights. ... If you want to see or change these permissions for this group, go to 'Site Settings' / 'Go to Site Administration' / 'Manage Site Groups', click on 'Web Designer and then select 'Edit Site Group Permissions' ...
    (microsoft.public.windows.server.sbs)
  • Re: User Profiles
    ... the new hive to allow the domain user. ... In addition to the NTFS file permissions on the profile directories, ... are permissions contained in the registry hive stored in ntuser.dat (which ... New User Accounts May Not Be Permitted to Use User Profiles ...
    (microsoft.public.windows.server.active_directory)
  • Re: Adding a database to existing workgroup file
    ... Did you define a pwd for Admin in the custom mdw? ... I went back and checked the User group permissions on the newly secured ... The Users group has no permissions at all (I did check the database ... > these dbs and Access as well, then reopen Access to rejoin the system.mdw ...
    (microsoft.public.access.security)