Solved

Logins and User Difference..

Posted on 2000-02-29
8
320 Views
Last Modified: 2009-09-02
Wht's the difference between the "Users" and the "Logins" under the Security in SQL Server 7..?


0
Comment
Question by:Silverprex
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
8 Comments
 
LVL 6

Expert Comment

by:Jon_Raymond
ID: 2571272
A user is one part of the login account.  The password is another part.

A SQL Server user forms one part of SQL Server security implementation. A user represents either a SQL Server login or Microsoft Windows NT® security account with data access privilege within a SQL Server database.
0
 
LVL 6

Accepted Solution

by:
crsankar earned 30 total points
ID: 2571858
In sql server a login account is created at the server level and provides access to the server. In order to access the databases within a sql server installation the login account that you create must be mapped to a user account within the database. Each database has its own security accounts called users which controls the permissions of that user within the database. Simply having a login account will enable you to access only those  databases which has a special user account called guest. If you want to provide a login account with access to a particular database create a user account within the database and map it to the login account.
0
 

Author Comment

by:Silverprex
ID: 2576682
In my SQL Server, I have there 2 databases resides in the same server . The other is the original database while the other is a replica'. I want to give the user a full access in all the tables in the replica alone. If Im to grant them the "Systems Administrator" under Security then Logins they can also access the original database.
How am I going to do this'..?

0
Why You Need a DevOps Toolchain

IT needs to deliver services with more agility and velocity. IT must roll out application features and innovations faster to keep up with customer demands, which is where a DevOps toolchain steps in. View the infographic to see why you need a DevOps toolchain.

 
LVL 6

Expert Comment

by:Jon_Raymond
ID: 2578860
Create a login to be used for the database only.  Then go to that database and expand it.  Click on USERS.  The right click in the right pane to add a new user, "New Database User...".  There you select the login name for this new user.  You can check all the permissions listed for this database, and the user will still only have the PUBLIC role permissions in other databases.  Make sure that PUBLIC doesn't have too many permissions (select public, check properties).

You don't have to give any permissions under SECURITY | LOGINS for this login user.  Just give the login database access there.

So, there are two places you have to check:  SECURITY | LOGINS under the server group; and USERS under the database group.
0
 
LVL 6

Expert Comment

by:crsankar
ID: 2582413
In the replica database create a user for the login account and make the user account member of the dbowner fixed database role.
0
 

Author Comment

by:Silverprex
ID: 2582581
Can't find from the drop down the Login I created (Under Security then Logins).
1st Step I cretaed : Agent Logins (under the Security then Logins).
2nd Step : Im to create a user by means of right click then "New Database User" Then there's this drop down "Logins" but I can't find the Logins I created. Why is that'..?
0
 
LVL 6

Expert Comment

by:crsankar
ID: 2582607
Are you able to see those logins under the security->login?
0
 
LVL 6

Expert Comment

by:Jon_Raymond
ID: 2585904
Under Security, Logins you have to set permissions for the login user and assign permission to the database in the Databse Access tab.
0

Featured Post

Is Your DevOps Pipeline Leaking?

Is your CI/CD pipeline a hodge-podge of randomly connected tools? You’ve likely got a tool to fix one problem & then a different tool to fix another, resulting in a cluster of tools with overlapping functionality. Learn how to optimize your pipeline with Gartner's recommendations

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
CAST issue with SQL 2000 15 44
EF5 How do I stop pre-compiled views? 8 57
Creating a View from a CTE 15 50
T-SQL Query 9 37
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question