|
Home > Archive > MS SQL Server > July 2005 > Database Owner
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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
| |
| Hari Prasad 2005-07-27, 3:23 am |
| 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
>
| |
| zashah@gmail.com 2005-07-27, 3:23 am |
| 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...
| |
| Wojtek Garwol 2005-07-27, 8:23 pm |
| 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
>
|
|
|
|
|