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...
quote:
> Not sure what information you are exactly looking for, but you can get
most
quote:
> information from sp_helprotect, sp_helpuser & sp_helprole system
procedures.
quote:|||other two has has good recommendation and that is very root of the
> Please refer to SQL Server Books Online for more information on these
> procedures.
> --
> Anith
>
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.
No comments:
Post a Comment