Solved

database and application

Posted on 2013-12-04
10
151 Views
Last Modified: 2013-12-19
i have an application which needs SQL database . Application needs to add users on the application administration level with different permissions (user , changer etc ) . Do i need to create users also on SQL database ? All users are on Domain
0
Comment
Question by:techp
  • 5
  • 4
10 Comments
 
LVL 10

Expert Comment

by:HuaMinChen
ID: 39694837
Yes, different users have their specific privileges on database objects. Read
http://technet.microsoft.com/en-us/library/ms187965.aspx
http://technet.microsoft.com/en-us/library/ms188371.aspx
0
 

Author Comment

by:techp
ID: 39695236
Do i need to create users also on SQL database ? is it not enough create users on application and connect to database
0
 
LVL 10

Expert Comment

by:HuaMinChen
ID: 39697244
Hi Techp,
Yes, there should be database users in your application.
0
 

Author Comment

by:techp
ID: 39697409
hello huaminchen,

 question is , is it necessary to add users in SQL database server ? is it not enough adding users in application
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 10

Expert Comment

by:HuaMinChen
ID: 39697439
Yes, you can also have the relevant user in the database.
0
 

Author Comment

by:techp
ID: 39697484
hello huaminchen,

question , is it must to add users in SQL database server to work on application ......or is it enough to add users on application and connect database. (all active directory users )
0
 
LVL 10

Expert Comment

by:HuaMinChen
ID: 39697525
For instance, you have
john.smith

in active directory. You can also create the same user in database and further grant him with relevant privileges.
0
 

Author Comment

by:techp
ID: 39697570
i am expecting clear answer for the question

question , is it must to add users in SQL database server to work on application ......or is it enough to add users on application and connect database. (all active directory users )
0
 
LVL 10

Accepted Solution

by:
HuaMinChen earned 500 total points
ID: 39697588
It is not a must, as it depends on how you design the application.
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

758 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now