Determining User's Effective Rights

From: Bob Hilton (bhilton@psmanagement.net)
Date: 10/26/02 

From: "Bob Hilton" <bhilton@psmanagement.net>
Date: Sat, 26 Oct 2002 09:21:31 -0700

I am using Windows 2000 and SQL Server 2000 in Windows
Authentication mode in a single domain with 40 servers.
Users are Members of Functional Groups with a
corresponding Role in SQL 2000. Users may be in more than
one Windows 2000 Group and the corresponding groups' Roles
may be members of multiple application Roles within the
database. Is there a tool that will allow me to determine
the Effective Rights for a given user? sp_helpuser
reports for the "domain" groups but does not go to the
individual users. With over a dozen groups and hundreds
of users, this is a real bear to do by hand.

Any help with ideas or tools is greatly appreciated.

Relevant Pages

  • Re: sp_revoke login is not working as expected.
    ... when I use DROP LOGIN and subsequently try to connect i get the folloiwng ... Since sysadmin role members are mapped to the dbo user in all databases, ... SQL Server MVP ... All of them are also a part of a windows group which has required ...
    (microsoft.public.sqlserver.security)
  • Re: sp_revoke login is not working as expected.
    ... Since sysadmin role members are mapped to the dbo user in all databases, you don't need to explicitly grant database access in that case. ... SQL Server MVP ... Does the Windows ...
    (microsoft.public.sqlserver.security)
  • Re: Determining Users Effective Rights
    ... See is the T-SQL PERMISSIONS built-in function provides you what you need. ... Documentation on the PERMISSIONS function can be found in the SQL Server ... > I am using Windows 2000 and SQL Server 2000 in Windows ... > may be members of multiple application Roles within the ...
    (microsoft.public.sqlserver.security)
  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Slow booting xp home.
    ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)