Romantic_touch


how can I create sql database file and it cann't be use or open (open mean to design view or structure) .

my case is: I have Acces db and this db has its own username and password, no body can read, write or view the designing, so it is useless. But there are somesoftware able to break and hacking db access. I think sql database file is more secure, so how can I do it





Re: protected sql database file

Arnie Rowland


If I understand you correctly, you want a way to prevent anyone from using any type of bit reader or editing tool and be able to read the raw datafile -such as using Notepad.

You may wish to explore the use of EFS. The Encrypting File System is part of windows and will allow you to create a file that can be used only when the user (or service) is the owner and properly logged in.







Re: protected sql database file

Jens K. Suessmeyer

Hi,


datafile of SQL Server can¡¯t be secured unless EFS encrypted, you will have to make sure that noone can get phyiscal access to the files, take the files with them and attach them to their own copy of SQL Server (where they probabaly have sa rights)

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---






Re: protected sql database file

Romantic_touch

not secure for me at this case mean encryption.........

what I mean by secure is, how to avoid read or edit database data or structure without username and password.






Re: protected sql database file

Hemantgiri S. Goswami

Hi,

Their are many ways you can secure your database refer http://hemantgirisgoswami.blogspot.com/2006/07/securing-sql-server.html

You may restrict user accessing your database by creating User/Role and assigning proper privilege to them but if their is a SA privilege of BOX to user he/she can easily reset the privilege. for e.g. you have a database named 'mydb' and you have created a user 'myuser' you have assignt access permission to this user using sp_grantdbaccess to 'myuser' , add 'myuser' to fixed database role (as per your requirement) then except SA other user can not see your database.

Hemantgiri S. Goswami






Re: protected sql database file

Romantic_touch

Hi.....

Thanks for your solution,

there is a quetion plz.

Can I Change the owner of the database

I mean I will create the database by sa user, and I will add new user, can I make him the owner






Re: protected sql database file

Jens K. Suessmeyer

Hi,

sp_changedbowner

HTH, Jens K. Suessmeyer.

---
http://www.sqlserver2005.de
---




Re: protected sql database file

Hemantgiri S. Goswami

Hi,

sp_changedbowner NEWUSER will change db owner as newuser for current database , refer BOL for sp_changedbowner for more.

Hemantgiri S. Goswami