Hello,
When I create new Database User the login name input does not show on the list and in the "login name " when checking the Properties of the name. Why this behavior?
the previous user created a while ago are showing name and login name .
permissions and rights are the same for between different users having the two different behaviors.
When I created the new database user I input e.g.:
Login Name: AD\<<User Name>>
Name : "First Name"
Thanks,
DomRight-click on "Login" in the folders window and select "Refresh". Enterprise Manager is a GUI, and is not always aware of changes to the underlying database.|||Thanks for the info It helped me discover that the user present in the "Users" container displayed their Login only if they are present in the "Logins" container.
Does it mean I need to create all Logins before adding Database users?
Thanks,
DOm|||That is the general order of things...
You should really create your ROLEs first, and grant them appropriate permissions. Then create the logins, grant them access to the database, and assign them to the roles.
No comments:
Post a Comment