Database Owner

Dear friends

I have a question,please help me.
I have a database and one of my database user is the owner of my database.
If i detach my database , i can attach it on other instance of SQL SERVER
with user of 'sa'.I want to stop this action in term of security.

Thanks
Mehdi

Hi,

SA is the system administrator and you cant restrict the permissions to
attach the database.

Thanks
Hari
SQL Server MVP

"Mehdi" <Mehdi@discussions.microsoft.com> wrote in message
news:E312383F-AB28-4B51-BE85- 59B605BE118F@microso
ft.com...
> Dear friends
>
> I have a question,please help me.
> I have a database and one of my database user is the owner of my database.
> If i detach my database , i can attach it on other instance of SQL SERVER
> with user of 'sa'.I want to stop this action in term of security.
>
> Thanks
> Mehdi
>

However, AFTER you've re-attached the database you can change the
database owner using sp_changedbowner.

ALI

Hari Prasad  wrote:[color=darkred
]
> Hi,
>
> SA is the system administrator and you cant restrict the permissions to
> attach the database.
>
> Thanks
> Hari
> SQL Server MVP
>
> "Mehdi" <Mehdi@discussions.microsoft.com> wrote in message
> news:E312383F-AB28-4B51-BE85- 59B605BE118F@microso
ft.com... 

You can achieve this security target only outside of SQL - restricting the
access to the detached database files. If someone can get access to those
files - he has access to the data inside, no way to prevent it.

Encryption of database files would be appropriate here - but it is not
available in SQL - only network communication and procedure bodies can be
encrypted.

Cheers
Wojtek


"Mehdi" <Mehdi@discussions.microsoft.com> wrote in message
news:E312383F-AB28-4B51-BE85- 59B605BE118F@microso
ft.com...
> Dear friends
>
> I have a question,please help me.
> I have a database and one of my database user is the owner of my database.
> If i detach my database , i can attach it on other instance of SQL SERVER
> with user of 'sa'.I want to stop this action in term of security.
>
> Thanks
> Mehdi
>