Hiding system objects in Enterprise manage, how?

Can't seem to find how to hide the tables that start with sys in the tables
list. I know it can be done, just can't remember how.
Any help greatly appreciated.
Bob
Right-click on the SQL Server in Enterprise Manager and select Edit SQL
Server Registration properties...
then uncheck the show system databases and system tables.
HTH
Jerry
"RDufour" <rdufour@.sgiims.com> wrote in message
news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
> Can't seem to find how to hide the tables that start with sys in the
> tables
> list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
>
|||RDufour wrote:
> Can't seem to find how to hide the tables that start with sys in the
> tables list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
I don't believe there is any way to prevent access to (or seeing) the
system tables in SQL Server 2000.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||David Gugick wrote:
> RDufour wrote:
> I don't believe there is any way to prevent access to (or seeing) the
> system tables in SQL Server 2000.
I stand corrected... on the SQL EM setting, that is.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Thanks,
Maybe I"ll end up remebering it next time :-)
Bob
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:eqIX0xuuFHA.3688@.tk2msftngp13.phx.gbl...
> Right-click on the SQL Server in Enterprise Manager and select Edit SQL
> Server Registration properties...
> then uncheck the show system databases and system tables.
> HTH
> Jerry
> "RDufour" <rdufour@.sgiims.com> wrote in message
> news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
>

Hiding system objects in Enterprise manage, how?

Can't seem to find how to hide the tables that start with sys in the tables
list. I know it can be done, just can't remember how.
Any help greatly appreciated.
BobRight-click on the SQL Server in Enterprise Manager and select Edit SQL
Server Registration properties...
then uncheck the show system databases and system tables.
HTH
Jerry
"RDufour" <rdufour@.sgiims.com> wrote in message
news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
> Can't seem to find how to hide the tables that start with sys in the
> tables
> list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
>|||RDufour wrote:
> Can't seem to find how to hide the tables that start with sys in the
> tables list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
I don't believe there is any way to prevent access to (or seeing) the
system tables in SQL Server 2000.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David Gugick wrote:
> RDufour wrote:
> I don't believe there is any way to prevent access to (or seeing) the
> system tables in SQL Server 2000.
I stand corrected... on the SQL EM setting, that is.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Thanks,
Maybe I"ll end up remebering it next time :-)
Bob
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:eqIX0xuuFHA.3688@.tk2msftngp13.phx.gbl...
> Right-click on the SQL Server in Enterprise Manager and select Edit SQL
> Server Registration properties...
> then uncheck the show system databases and system tables.
> HTH
> Jerry
> "RDufour" <rdufour@.sgiims.com> wrote in message
> news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
>

Hiding system objects in Enterprise manage, how?

Can't seem to find how to hide the tables that start with sys in the tables
list. I know it can be done, just can't remember how.
Any help greatly appreciated.
BobRight-click on the SQL Server in Enterprise Manager and select Edit SQL
Server Registration properties...
then uncheck the show system databases and system tables.
HTH
Jerry
"RDufour" <rdufour@.sgiims.com> wrote in message
news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
> Can't seem to find how to hide the tables that start with sys in the
> tables
> list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
>|||RDufour wrote:
> Can't seem to find how to hide the tables that start with sys in the
> tables list. I know it can be done, just can't remember how.
> Any help greatly appreciated.
> Bob
I don't believe there is any way to prevent access to (or seeing) the
system tables in SQL Server 2000.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||David Gugick wrote:
> RDufour wrote:
>> Can't seem to find how to hide the tables that start with sys in the
>> tables list. I know it can be done, just can't remember how.
>> Any help greatly appreciated.
>> Bob
> I don't believe there is any way to prevent access to (or seeing) the
> system tables in SQL Server 2000.
I stand corrected... on the SQL EM setting, that is.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Thanks,
Maybe I"ll end up remebering it next time :-)
Bob
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:eqIX0xuuFHA.3688@.tk2msftngp13.phx.gbl...
> Right-click on the SQL Server in Enterprise Manager and select Edit SQL
> Server Registration properties...
> then uncheck the show system databases and system tables.
> HTH
> Jerry
> "RDufour" <rdufour@.sgiims.com> wrote in message
> news:OzibnwuuFHA.252@.TK2MSFTNGP09.phx.gbl...
> > Can't seem to find how to hide the tables that start with sys in the
> > tables
> > list. I know it can be done, just can't remember how.
> > Any help greatly appreciated.
> >
> > Bob
> >
> >
>

HIding databases that a user does not have permission to

I remember reading a blog post which showed you how to hide databases other than the ones the current user has permission to see. My ISP is getting a lot more SQL 2005 databases on the server and I would like to encourage them to only show me mine in Management Studio rather than the huge list I have to scroll down. Is this possible?

(the blog post *may* have been for SQL 2000 but I'm looking for a SQL 2005 solution)

Yes, there have been some recent discussions about this. You need to revoke the permission 'VIEW ANY DATABASE' from the role PUBLIC (and then grant it to any server principal who should have it but don't get it by default). Credit to Kalen Delaney and Dan Guzman who pointed this out... wrote in message news:b45aadf8-59d9-4531-9ba7-dac473bbcade@.discussions.microsoft.com... >I remember reading a blog post which showed you how to hide databases
> other than the ones the current user has permission to see. My ISP is
> getting a lot more SQL 2005 databases on the server and I would like to
> encourage them to only show me mine in Management Studio rather than the
> huge list I have to scroll down. Is this possible? >
> (the blog post *may* have been for SQL 2000 but I'm looking for a SQL
> 2005 solution) > > >
>