I'm creating a SOX compliance report in Reporting Services 2000 via SQL
Server 2000. We will be upgrading in the next 3 months to 2005 on both, so I
need this question answered for both databases.
How do I pull permissions & fixed roles for all mapped NT accounts?
I can find the many of the names in Syslogins mapped to their default
databases, but it doesn't give me a list of ALL the dbs the Login has access
to. Also, when I go to <dbname>.dbo.SysUsers, it will give me the list of
people who specifically have access to that database, but not what DB roles
that might have.
What am I missing? I need a comprehensive list of these permissions on our
database.
The report format we're going with is:
<ServerName>
<DatabaseName>
<ServerLogin> <Server or App Roles belonging to Login>
<Database logins>
<Database Roles>
<Table/View/SP/UDF permissions>
Thanks for any suggestions or help anyone can give me on this!
Catadmin
--
MCDBA, MCSA
Random Thoughts: "First things first, but not necessarily in that order."
-- Doctor WhoI'd ask this in one of the other SQL Server newsgroups.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Catadmin" <goldpetalgraphics@.yahoo.com> wrote in message
news:9F07D7A9-F2A0-4956-9E78-699143248F2C@.microsoft.com...
> I'm creating a SOX compliance report in Reporting Services 2000 via SQL
> Server 2000. We will be upgrading in the next 3 months to 2005 on both,
> so I
> need this question answered for both databases.
> How do I pull permissions & fixed roles for all mapped NT accounts?
> I can find the many of the names in Syslogins mapped to their default
> databases, but it doesn't give me a list of ALL the dbs the Login has
> access
> to. Also, when I go to <dbname>.dbo.SysUsers, it will give me the list of
> people who specifically have access to that database, but not what DB
> roles
> that might have.
> What am I missing? I need a comprehensive list of these permissions on
> our
> database.
> The report format we're going with is:
> <ServerName>
> <DatabaseName>
> <ServerLogin> <Server or App Roles belonging to Login>
> <Database logins>
> <Database Roles>
> <Table/View/SP/UDF permissions>
> Thanks for any suggestions or help anyone can give me on this!
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: "First things first, but not necessarily in that order."
> -- Doctor Who
>
No comments:
Post a Comment