Re: plz-help enumeration database objects that users roles have ?

From: Anith Sen (anith_at_bizdatasolutions.com)
Date: 01/28/04 

Date: Wed, 28 Jan 2004 09:19:58 -0600

Not sure what information you are exactly looking for, but you can get most
information from sp_helprotect, sp_helpuser & sp_helprole system procedures.
Please refer to SQL Server Books Online for more information on these
procedures. 

-- 
Anith

Relevant Pages

  • Re: sp_add_message - Internals Mystery - Help!!!!
    ... Furthermore, system procedures no longer live in the master database, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: xp_logevent and service broker queues
    ... Sinec the sp_ prefix is reserved for system procedures, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Using variable in Stored procedure - help!
    ... Between @startdate AND @enddate' ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: xp_regread
    ... No...there are over a dozen other system procedures that ... call xp_regread so you will break some SQL Server ... functionality. ... Removing system objects is not a good idea and can result in ...
    (microsoft.public.sqlserver.security)