Managing permissions, user and group accounts in MSDE

Hello
I have little experience of MSDE but have worked with SQL Server at various
locations in the past.
Can anyone tell me the easiest way to manage permissions, user and group
accounts etc. in the absence of enterprise manager.
Does everything have to be scripted?
Many thanks
Mark
hi Mark,
Mark wrote:
> Hello
> I have little experience of MSDE but have worked with SQL Server at
> various locations in the past.
> Can anyone tell me the easiest way to manage permissions, user and
> group accounts etc. in the absence of enterprise manager.
> Does everything have to be scripted?
you can script out part of your management, but you probably have to
interactively perform some administration too... you can have a look at
http://support.microsoft.com/default...;EN-US;q325003 for some
hints on oSql.exe use for that... and/or you can resort on third party
management tools... some of them, both free and commercial, are listed at
http://www.microsoft.com/sql/msde/partners and
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks Andrea :@.)
Mark

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?