Managing Permissions

I am having trouble managing permission and am looking for a solution. My
databases has 150 tables, 5 Roles and ~40 logins. And I have a 2 inch by 3
inch window to check and uncheck table/Column permissions. This is
frustrating!!! Is this data held in one of the system tables? Is there som
e
additional software to handle this?Hi,
See "GRANT" and "REVOKE" commands in SQL Server Books online.
Thanks
Hari
SQL Server MVP
"Matt Sonic" <MattSonic@.discussions.microsoft.com> wrote in message
news:3F3DE2FD-C2F3-4DA3-849F-1F7BC167B87F@.microsoft.com...
>I am having trouble managing permission and am looking for a solution. My
> databases has 150 tables, 5 Roles and ~40 logins. And I have a 2 inch by
> 3
> inch window to check and uncheck table/Column permissions. This is
> frustrating!!! Is this data held in one of the system tables? Is there
> some
> additional software to handle this?|||Check out http://www.agileinfollc.com DataStudio
"Matt Sonic" <MattSonic@.discussions.microsoft.com> wrote in message
news:3F3DE2FD-C2F3-4DA3-849F-1F7BC167B87F@.microsoft.com...
>I am having trouble managing permission and am looking for a solution. My
> databases has 150 tables, 5 Roles and ~40 logins. And I have a 2 inch by
> 3
> inch window to check and uncheck table/Column permissions. This is
> frustrating!!! Is this data held in one of the system tables? Is there
> some
> additional software to handle this?