Post reply

How to Hide the system databases list from Combo Box in Query Analyser?

  • December 7, 2004 at 8:07 am

    #152320

    Hi,

         we are in need of allowing the particular users to view only the granted User Database(s) and hide the other databases from the combo box in the Query Analyzer whether it is possible to Hide atleast system databases(master,model,msdb,tempdb) from Combo Box in Query Analyzer?

     

    Hoping that everyone gets the scene Please help with it

     

    Thanks a bunch.

  • December 8, 2004 at 1:55 am

    #532987

    Their SQL login should prevent them from querying the system databases unless they are 'sysadmin' level people, so even though they can see them, they shouldn't be able query those tables.

     

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply