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.
| 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. AccountDb2. InventoryDb.I have 2 application. Account Application and Inventory ApplicationHow do i need to do on creation 2 username and password so that Account .Net application only able to((Select, Delete, Update, Insert) AccountDB andInventory .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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Security configuration