Database Security

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ajami - 27 Jul 2005 10:06 GMT

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 .

Signature

Daryoush Ajami

Reply to this Message

Hari Prasad - 27 Jul 2005 21:09 GMT

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

> Hi,
> I have created a database in server SRV1 with user 'aaa' as database owner
[quoted text clipped - 4 lines]
> How can restric my database for other server and other sa youser ther ?
> Tanks .

Reply to this Message