This post has been wikified, any user with enough reputation can edit it.
asked
user login restricted to one database
hi is there possible in sql server that one login user restricted to one particular database? My server have 20 database, today i have created one login with public server role. but my requirement is as i created one login must be access only one database but do not access remaining 19 database. I am using sql server 2005. Is it possible? if then how can i do it? plz any one help me........
Logins are associated to users by the security identifier (SID). A login is required for access to the SQL Server server. The process of verifying that a particular login is valid is called "authentication". This login must be associated to a SQL Server database user. You use the user account to control activities performed in the database. If no user account exists in a database for a specific login, the user that is using that login cannot access the database even though the user may be able to connect to SQL Server. The single exception to this situation is when the database contains the "guest" user account. A login that does not have an associated user account is mapped to the guest user. Conversely, if a database user exists but there is no login associated, the user is not able to log into SQL Server server.
9 People are following this question.
