Re: SQL database view

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 11/28/05

  • Next message: CB: "Encrypted values are different although the source is the same" 
    Date: Mon, 28 Nov 2005 17:26:05 -0500

    There is no way to limit this in SQL2000. This is fixed in SQL2005. 

    -- 
Andrew J. Kelly  SQL MVP
"Kelvin Yan" <kyan@extron.com> wrote in message 
news:%23N49NaG9FHA.736@TK2MSFTNGP09.phx.gbl...
>I have 20 databases in a SQL box but only want users to see that databases 
>they are allowed. If I gave 1 user access to 1 database when they login in 
>EM it shows all 20 even though they cannot get into the other 19 it stills 
>shows up. Any advise? I seen this done before on ISP who host sql 2000. I 
>only can see my own db not anyones else's.
>
  • Next message: CB: "Encrypted values are different although the source is the same"

    Relevant Pages

    • Re: BizTalk eating up SQL Server (Virii Behaviour)
      ... Yes, one gig is the least to run sql & bts in the same box, ... uninstall procedure, i manually deleted all databases, and run the ... and it was leaving like 20 mbs free memory, ... BizTalk Solution Developer ...
      (microsoft.public.biztalk.general)
    • Re: Dont understand what version of SQL to install
      ... I'm talking about developing and testing databases for my client and ... To my XP, I can add SQL Developer 2008 to develop (I guess I should say, ... So I can use SQL Developer 2008 to create a database in standard 2005, ... installed on Client OSs such as Windows Vista. ...
      (microsoft.public.sqlserver.setup)
    • Re: Relational-to-OOP Tax
      ... Many SQL vendors has text mining features. ... Tutorial D isn't availible in production databases. ... The Third Manifesto,2 object functionality and the relational model are ...
      (comp.object)
    • Re: [PHP] is there a problem with php script pulling HTML out of database as it writes the page??
      ... I even had one tell me "SQL injection? ... about databases, server management, mail, or anything. ... I have a ghostwriter who keeps me active on the mailing lists. ...
      (php.general)
    • DataArchitect Version 3.5 Now On HP-UX
      ... DataArchitect is a powerful tool that provides ERD capability like PowerDesigner as well as the ability to graphically reverse engineer, create and modify a database through ODBC and perform advanced SQL functions. ... Data Architect is an emerging enterprise tool for designing databases at all levels of an organization using the same concepts found in tools costing thousands of dollars! ... Minimize/Maximize feature on diagram objects ...
      (comp.sys.hp.mpe)