Avatar of techp
techpFlag for India asked on

database and application

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
Microsoft SQL ServerMicrosoft SQL Server 2008Microsoft Legacy OS

Avatar of undefined
Last Comment
Peter Chan

8/22/2022 - Mon
Peter Chan

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
ASKER
techp

Do i need to create users also on SQL database ? is it not enough create users on application and connect to database
Peter Chan

Hi Techp,
Yes, there should be database users in your application.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER
techp

hello huaminchen,

 question is , is it necessary to add users in SQL database server ? is it not enough adding users in application
Peter Chan

Yes, you can also have the relevant user in the database.
ASKER
techp

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 )
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Peter Chan

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.
ASKER
techp

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 )
ASKER CERTIFIED SOLUTION
Peter Chan

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question