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