Member Avatar for domingo
domingo 0 Light Poster

sry guys but i am new to MVC i just want to ask if it is possible to assign a connection string to a particular user from a database (Example) i want to restrict user from selecting a table, which can be done by using SQL Managment studio. This is the connection string i am assigning.

<add name="MusicStoreEntities" connectionString="Data Source=.\SQLEXPRESS; Initial Catalog=MvcStore;User =NONAdminDB;password=123;Integrated Security=SSPI"

The problem is that if for user NONAdminDB i restricted a permission to select from a table when i make the LINQ statment the data is shown, can anyone help me with this problem please?

  • 1 Contributor
  • 0 Replies
  • 83 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.