How to create database having userid and password

Hi,
I am using the sql server for creating the database. I want to create the database which is having userid and password. This I require since I wanted to restrict acces to database and also only authorise user to database can use the userid and password created at time of creation of database.
So how can I create the database which is having userid and password?The situation you mention is not possible. SQL Server datafiles have to be secured at OS level, if not they can be deattached, copied and attached to any other instance.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

Hi,

But I think that the user who creates the database has the right to decide the users of the database. Or can u give any alternative way to protect the database from other users.

|||

See... that is how SQL Server Security Model works... SQL Server has two level security ... One at the serverl level (LOGIN) and one at the database Level (USER)... If u have access to server(LOGIN) it does not mean that u have access to all the databases... No... u just cant do anything if u have only login... these login has to have permission(added) to a database to access the database... The only thing is that how u understand and interpret the architecture..

MikeRt wrote:

Hi,

But I think that the user who creates the database has the right to decide the users of the database. Or can u give any alternative way to protect the database from other users.

just don't add any other user to the database ... then only the owner will have the permission... read about dabase role /server role in BOL... This is a normal requirement and u can do this simply setting user/login in right role...

Madhu

|||

Thanks for clerifying the concept.

But to access the master database 'sa ' is the universally fix login. U can access the Master database using 'sa' login. Then u can create the database.

So I want to give the database I(application) created userid and password so that even if sql server is having some login id and password The application can access the newly created database using its own id and password.This also doesn't warrent application to know the login and password for sql server.And application works independently. Can it be possible and how?

MikeRT