Re: Protect and invirible Database from each other

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/16/04 

Date: Fri, 16 Jul 2004 11:11:28 -0400

Yes, SQL 2005 has a lot of improvements in this area. 

-- 
Andrew J. Kelly  SQL MVP
"Neung" <Neung@discussions.microsoft.com> wrote in message
news:032A5CFE-D0D9-4727-8032-707D90436D80@microsoft.com...
> Thanks and hope it will be solved in the next version.
>
> Regards,
> Neung
>
>
> "Andrew J. Kelly" wrote:
>
> > There is no way currently to stop them from seeing the other databases.
But
> > unless you give them specific permissions they can not access or view
the
> > data in them.
> >
> > -- 
> > Andrew J. Kelly  SQL MVP
> >
> >
> > "Neung" <Neung@discussions.microsoft.com> wrote in message
> > news:F5F3F38C-8F8B-499F-8C9C-7BE19D350C9A@microsoft.com...
> > > Hi,
> > >
> > > I'm using Windows 2000 Server + SQL Server 2000 + updated SP
> > >
> > > This server is our Web Hosting services and we have many database in
SQL
> > Server.
> > >
> > > Each databases are belonged to each customer domains in this Server.
> > >
> > > All customers work with SQL Server by using SQL Enterprise Manage to
> > connect to the Server via TCP/IP.
> > >
> > > My problem is that, after customers connect to the SQL Server, they
can
> > see every Databases' name and table name although I'd set the right of
each
> > customer to be able to see only their own database.
> > >
> > > I'd ask many SQL Experts but they said that if I used SQL Enterprise
> > manager to remote connect to the SQL Server, this senario could not be
> > protected and let me ask Microsoft.
> > >
> > > Using SQL Enterprise Manager is the easiest way for my customer to
manage
> > their database, so if I let them use the SQL command line to connect to
the
> > SQL Server, no customers will use my service.
> > >
> > > Please help.
> > > Regards,
> > > Neung
> >
> >
> >

Relevant Pages

  • Re: Create SQL cluster on 2003
    ... Since you are in a cluster configuration, ... Microsoft SQL Server MVP ... We only about about 20 databases - all ... Move Databases Between Computers That Are Running SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: Help!! Trying to migrate data from one SQL to another?!?
    ... I came up to the window on the DTS Wizard which has the option to ... I can defend myself on PL/SQL but I am not much of a SQL Server ... The application performs a replication between databases but due to ...
    (microsoft.public.sqlserver.dts)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... "In some cases, you may want to copy the system databases, including the ... from the source SQL Server 2000 instance to the SQL ... System Databases" in SQL Server 2005 Books Online to see how to do this" ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... Microsoft SQL Server MVP ... MVP - Windows Server - Clustering ... from the source SQL Server 2000 instance to the SQL ... > 2005 instance before transferring user databases. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Update MSDE2000 to SQL2000 on same server
    ... Yes you do an upgrade from MSDE to SQL 2000 Enterprise. ... a full database backup of all databases. ... Step 2 Click SQL Server 2000 Components. ...
    (microsoft.public.sqlserver.setup)
Quantcast