Re: Database Security

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/27/05

  • Next message: Mike Epprecht \(SQL MVP\): "Re: Need Advice - encrypt data in transit" 
    Date: Thu, 28 Jul 2005 01:39:03 +0530

    Hi,

    First of all restirct the access to your SQL Server. In this case no one can
    detach the database and attach in SRV2.

    FYI, If he have detach database access in sql server and copy the files from
    operating system then he will be able to
    attach the database in his server and view all tables and objects.

    Thanks
    hari
    SQL Server MVP

    "Ajami" <Ajami@discussions.microsoft.com> wrote in message
    news:34C340B7-2451-4E9C-8227-EA0AA0DF7573@microsoft.com...
    > Hi,
    > I have created a database in server SRV1 with user 'aaa' as database owner
    > Know if some body detach this database from SRV1 and attach them on other
    > server same SRV2 with defrent sa and defrent users 'SA' user in SRV2 has
    > full
    > access to may database
    > How can restric my database for other server and other sa youser ther ?
    > Tanks .
    >
    > --
    > Daryoush Ajami

  • Next message: Mike Epprecht \(SQL MVP\): "Re: Need Advice - encrypt data in transit"

    Relevant Pages

    • Re: statement not allowed within multi-statement transaction (Long)
      ... So if I do have an open transaction I can't figure ... > 100 Database does not exist in sysdatabases can not dettach ... > --Verify database Exiists for detach ... >> Wayne Snyder, MCDBA, SQL Server MVP ...
      (microsoft.public.sqlserver.programming)
    • Frequent use of attach and detach
      ... We are considering an architecture in which "detach" and "attach" are used ... We want to have a farm of load servers for a data warehouse. ... database file "F" and loads data. ...
      (microsoft.public.sqlserver.server)
    • Re: MS Access DAO -> ADO.NET Migration
      ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Cluster will not fail over.
      ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
      (microsoft.public.sqlserver.clustering)
    • Re: register database
      ... MSDE will not come up with normal tools graphical tools. ... This will go go to a sql prompt, there execute the sp_attach_db to attach ... This will attach the database to sql server. ...
      (microsoft.public.sqlserver.server)