Re: Database security

From: VUILLERMET Jacques (jvuillermet_at_no-spam.fr)
Date: 08/01/03 

Date: Fri, 1 Aug 2003 15:18:30 +0200

Any System Administrators member can access everywhere.

I think new instance with no BUILTIN/administrators access.

Create a login with backup/restore right if the firm team has to backup.
But can they backup and restore on a different server and then see your data
?

Jacques.

"Johny" <goky2002@beograd.com> a écrit dans le message de news:
OK4uqW7UDHA.2568@tk2msftngp13.phx.gbl...
> I have client-server application. Server is MS SQL.
> I want to install my database in some firm and if they already have and
> using MS SQL how can I install database so they cant see data and possibly
> change them(database must be protected and no body from that firm
shouldn't
> have access trough MS SQL tools)?
>
> Should I create new instance or server or maybe use some tool?
>
> Thank you
>
>

Relevant Pages

  • Re: SBS2003, NTBackup-Fehler
    ... Windows Server 2003 to resolve some VSS snapshot issues ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.de.german.backoffice.smallbiz)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: Scheduled Backup for SQL Database
    ... Look in the SQL Server log too, ... Need smaller SQL2K backup files? ... >>Need smaller SQL2K backup files? ...
    (microsoft.public.sqlserver.server)
  • SQL/ MS 2003 server backups/restores
    ... I'm a bit confused on the backup necessary for my SQL server running on MS ... system state, OS etc, and another for my SQL databases. ...
    (microsoft.public.sqlserver.server)
  • Re: VSS event 6013
    ... I am experiencing a similar issue where VSS tries to access my SQL ... Server every time I perform a system state backup. ...
    (microsoft.public.windows.server.sbs)
Quantcast