I need help with one of the issues I am facing with SQL Server. I have two databases 1 and 2. Databases 2 has two tables. I need to give access to database 1 or a user in database 1 such that they can select and update the tables in database 2. These databases are in the same server.
In oracle, i would create the two users and grant select, update on TABLE_1 to user1.
As far as I know, you will need to create the user in database 2 (i.e., create a user and associate the login with the user). You can do this from SSMS object explorere - right-click the login name under server level security, select properties, and then user mapping. After you do that, you would grant permissions on those tables to the user.