plz-help enumeration database objects that users roles have ?

From: simo sentissi (simo_sentissi_at_skc.edu)
Date: 01/28/04 

Date: Wed, 28 Jan 2004 08:08:29 -0700

Hello

I I just inhertied a database that I am trying to document.
I have many user roles and users under this database. and I want to put in
the documentation the user roles and the tables and object they have access
to them. as well as the users under the roles.
ofcourse there are a lot of data and collecting it manually will take ages
so I am wondering if smbdy has any suggestion or some sql code that hits the
system tables ? I have never touched any system tables or DB and I have no
map or definition for them so I am pretty relunctant on diving in it ?

Simo

Relevant Pages

  • Re: Error 21002: [ SQL-DMO] User "xxxxx" already exists.
    ... you can drop the user from the database using ... > Can you please let me know how to resolve this. ... > then it is still visible under different user roles ... It does not delete the user account from ...
    (microsoft.public.sqlserver.security)
  • Re: Need to create in-memory store for authorization roles
    ... I know I can go get the roles from the database and add ... but would like to cache the roles in memory rather than ... > know that at the point where I need this the session state bag is not yet ... > Any thoughts on how best to create an in-memory store for user roles? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Error 21002: [ SQL-DMO] User "xxxxx" already exists.
    ... No restoration of database was performed. ... I do not see that user account as orphaned. ... >> then it is still visible under different user roles ...
    (microsoft.public.sqlserver.security)
  • Need to create in-memory store for authorization roles
    ... authorization. ... I know I can go get the roles from the database and add them ... know that at the point where I need this the session state bag is not yet ... Any thoughts on how best to create an in-memory store for user roles? ...
    (microsoft.public.dotnet.framework.aspnet)