October 29, 2008 at 8:54 am
I drilled down in the security of a server and assigned a database to a group and hit OK, i see that group in the database > security but when i again check the security under whole server i dont see it, i tried refresh but still i cudnt see the database checked there. WHY?
November 10, 2008 at 6:15 am
It sounds like you tried to add a group to a database, without first creating a login for the group.
Since it's possible in SQL 2005 to create databases users without login, this succeeds. But without the login the members of you're group can't access the server.
From a security point of view it would be a very bad idea if logins were created automatically for each database user without a login. In that case a db_owner could create new logins without being sysadmin or securityadmin.
Best proactice is always create the login first and then give the necessary database access to the login.
Hope this helps
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply