Click here to Skip to main content
15,887,746 members

Comments by Velkumar Kannan (Top 34 by date)

Velkumar Kannan 23-Feb-15 4:55am View    
It is a complex one.. I need a sample for this
Velkumar Kannan 23-Oct-12 5:51am View    
This is not my question.

We can use same connection string for all users and roles. But just use the conditions to access data from DB for different users and roles.

My question is

Why we should use many connection strings for different users and roles?
The developer can write the code to check the user type and roles Depends on this the developer can write the code of accessing data from DB.

What is the use of using different users in DB for one application?

Can you tell a real time example for using different users in DB for one web application?
Velkumar Kannan 23-Oct-12 4:45am View    
I cant understand. Can you give an explanation
Velkumar Kannan 23-Oct-12 4:44am View    
Good example. Nice example. Thanks for your post.

I also have one more doubt.

The web application users are authenticated in IIS level and asp.net level.

The connection strings and database access controls are in the hand of developers.
The web application users just interact with web application so the authentication process are handled in asp.net level.

If we want to access different data from table we can use the C# code to check the conditions. (Using same connection string for all users.)

The end users do nothing with the database since they just interact with the web site.

Can you explain one situation with this dynamic connection string?
Velkumar Kannan 23-Oct-12 3:33am View    
k. i accept this.

A web application should have one user. This user should have all permission to access the resources. Then which user has restrictions to access this resources.
This may be common for all web application.