Password Setting
-
Hi All, In general, Sql Server having its default password. We can change the password also. But if I want to set a password for individual Databases in SqlServer 2005, is it possible ? Thanks in advance.
-
Hi All, In general, Sql Server having its default password. We can change the password also. But if I want to set a password for individual Databases in SqlServer 2005, is it possible ? Thanks in advance.
I don't believe so. Logins and passwords aren't specified at the database level - but users are. I guess you'd say that logins are specified at the instance level. Logins are then mapped to users. You could create different logins and only give them access to specific databases. Scott
-
I don't believe so. Logins and passwords aren't specified at the database level - but users are. I guess you'd say that logins are specified at the instance level. Logins are then mapped to users. You could create different logins and only give them access to specific databases. Scott
scottgp is correct. dont map the database(s) that you dont want the user to have access to for that login.