Logins and User Difference..
Wht's the difference between the "Users" and the "Logins" under the Security in SQL Server 7..?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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'..?
How am I going to do this'..?
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.
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.
In the replica database create a user for the login account and make the user account member of the dbowner fixed database role.
ASKER
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'..?
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'..?
Are you able to see those logins under the security->login?
Under Security, Logins you have to set permissions for the login user and assign permission to the database in the Databse Access tab.
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.