Wednesday, March 21, 2012

plz-help enumeration database objects that users roles have ?

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 ?
SimoNot 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|||well I just want a listing of user roles and their security rights on DB
objects.
I am looking at the stored procs now but if there is soemthing already done
outhere then it will save me some work.
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:uYCCFJb5DHA.2404@.TK2MSFTNGP11.phx.gbl...
> 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
>|||other two has has good recommendation and that is very root of the
resolution. Not much more time you can save. If this is just for
information, other recommendations can get you that information in
5-10 mins. If this is more than just information gathering, you can
use PowerPoint, Access, Visio, SQL Diagram, and host of other
applications.sql

No comments:

Post a Comment