Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 Security configuration

Author  Topic 

calvinkwoo3000
Yak Posting Veteran

98 Posts

Posted - 2014-09-22 : 03:35:52
Dear dbadmin,

There are 2 Catalog in my sqlserver database.
1. AccountDb
2. InventoryDb.

I have 2 application. Account Application and Inventory Application

How do i need to do on creation 2 username and password so that Account .Net application only able to((Select, Delete, Update, Insert) AccountDB and
Inventory .Net application only able to(Select, Delete, Update, Insert) InventoryDb.


<connectionStrings>
<add name="Account_Connection" providerName="System.Data.SqlClient" connectionString="Data Source=MYServer;Initial Catalog=AccountDb;Persist Security Info=True;uid=account_sa;pwd=xxxxxx" />
</connectionStrings>

<connectionStrings>
<add name="Inventory_Connection" providerName="System.Data.SqlClient" connectionString="Data Source=MYServer;Initial Catalog=InventoryDb;Persist Security Info=True;uid=inventory_sa;pwd=yyyyyy" />
</connectionStrings>

What should i do in the Security, Roles and Users setting?

Thank in advance.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-09-22 : 12:53:28
Create login1, grant it read/write to database1.
Create login2, grant it read/write to database2.

Preferably you would be using stored procedures though so that you don't have to grab full read/write.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -