July 3, 2014 at 11:43 am
Hi,I need help regarding my issue.
We are using a application which is used by multiple users simultaneously.Using this application,different users are going to get the information from same database table.My problem here is multiple users are getting the same information.I want to have a control on this.So that accessing information of one user is not available to another user.How to do this.Thanks in advance.
July 3, 2014 at 11:56 am
cas001s (7/3/2014)
Hi,I need help regarding my issue.We are using a application which is used by multiple users simultaneously.Using this application,different users are going to get the information from same database table.My problem here is multiple users are getting the same information.I want to have a control on this.So that accessing information of one user is not available to another user.How to do this.Thanks in advance.
Wow that is extremely vague. Taking a shot in the dark here.
Add another column to your table(s) so you know what data any given user can view? Maybe add UserID (or whatever) to the columns. Then you would need to modify every query to include the extra predicate in the where clause.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply