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@.microsoft.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:[vbcol=seagreen]
> 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@.microsoft.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@.microsoft.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
>