Hi
I'm not sure if this is possible but does anyone know if there is a way to
create a MMC snap in for EM and only have certain features of EM showing in
that snap in e.g. not let the user see DTS jobs etc.
I know you can restrict access so the user won't have the rights to run
certain things but is it possible to set up so they don't even see certain
things when opening the snap in. I have had a look and can't see how this can
be done so any suggestions would be welcome.
Thanks
JonjoYou would have to do that on your own, quering the sql server via SQLDMO.
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"jonjo" <jonjo@.discussions.microsoft.com> schrieb im Newsbeitrag
news:5EAB76B4-016A-41F9-84D5-C2A405220C62@.microsoft.com...
> Hi
> I'm not sure if this is possible but does anyone know if there is a way to
> create a MMC snap in for EM and only have certain features of EM showing
> in
> that snap in e.g. not let the user see DTS jobs etc.
> I know you can restrict access so the user won't have the rights to run
> certain things but is it possible to set up so they don't even see certain
> things when opening the snap in. I have had a look and can't see how this
> can
> be done so any suggestions would be welcome.
> Thanks
> Jonjo|||... or also using the SQL.NS API (should save some work compared to only using DMO)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in message
news:uVJC6oJXFHA.3348@.TK2MSFTNGP14.phx.gbl...
> You would have to do that on your own, quering the sql server via SQLDMO.
> --
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "jonjo" <jonjo@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:5EAB76B4-016A-41F9-84D5-C2A405220C62@.microsoft.com...
>> Hi
>> I'm not sure if this is possible but does anyone know if there is a way to
>> create a MMC snap in for EM and only have certain features of EM showing in
>> that snap in e.g. not let the user see DTS jobs etc.
>> I know you can restrict access so the user won't have the rights to run
>> certain things but is it possible to set up so they don't even see certain
>> things when opening the snap in. I have had a look and can't see how this can
>> be done so any suggestions would be welcome.
>> Thanks
>> Jonjo
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment