InfoPath and SQL 08 Security Settng

Posted on 2009-12-17
Last Modified: 2012-05-08
I have more issues with IP and SQL,
We want to make an employee appraisal form that the supers fill out and it submits to a SQL DB.
We also want them to be able to query their old forms from the last appraisal to compare. but we dont want one super to see another supers apparaisals. So is there a way to make certain fields (In SQL08) only accessiable to certain people.
Question by:optikconnex
    LVL 28

    Accepted Solution

    There are multiple layers where you can apply security. In the form or in the database at a record or field level.

    I would recommend you investigate the webservice tools from  They do everything that you are looking for very easily.

    Otherwise I would lean toward using AD integration and only allowing the form user to see their own forms.  This is easier than trying to dynamically secure data in SQL.


    Author Closing Comment


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now