May 17, 2010 at 9:23 am
What is the difference between setting up a user under the 'Security' node and setting one up underneath the 'Databases' node?
I would guess that underneath that the Security node is for access to the server and the database node is for access to the specific database. Does a user have to be set up under both? (I would guess yes.)
May 17, 2010 at 9:33 am
Hi,
under the security node, a 'login' is created. It is instance specific. It is to logon to the instance. When a login is given access to a database, a user is automatically created under that database. A login can be given access to multiple databases which in turn creates individual users under those specific databases.
So, we do not create 'User' specifically. But we provide access to login for the required database. A user cannot exist with out its associated login. Hope, it is clear.
Thank you
[font="Verdana"]Renuka__[/font]
May 17, 2010 at 10:53 am
The explanation above is essentially correct. You can have users without logins as orphans after a restore, but essentially the login gets you access to the server, the user to a database.
May 18, 2010 at 6:56 am
An explanation I always liked was the shopping mall one. The 'logon' gets you entry to the mall as a whole (the server) but each shop inside is still locked. Adding a 'user' gets you access to each individual store(database) within the mall. 😛
May 18, 2010 at 4:30 pm
The permissions allow the person to look, buy, shop, refund, sell the store, trash it...
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply