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
ASKER
Do i need to create users also on SQL database ? is it not enough create users on application and connect to database
Hi Techp,
Yes, there should be database users in your application.
Yes, there should be database users in your application.
ASKER
hello huaminchen,
question is , is it necessary to add users in SQL database server ? is it not enough adding users in application
question is , is it necessary to add users in SQL database server ? is it not enough adding users in application
Yes, you can also have the relevant user in the database.
ASKER
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 )
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 )
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.
john.smith
in active directory. You can also create the same user in database and further grant him with relevant privileges.
ASKER
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 )
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://technet.microsoft.c
http://technet.microsoft.c