Databases
StackOverflow2013
Postsdbo
POWCF Web Service needs access to user name and password information
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWCF Web Service needs access to user name and password information
    primarykey
    data
    text
    <p>I have build a wcf web service that simply provides MS Dynamics SQL data to a CRM hosted Silverlight application. Currently the web services are hosted in IIS and are only available via HTTPS so the contents of the messages are secure. I'm now ready to implement the next level of security that has to do with who is logged into the Silverlight client application. I'd like to pass that information to the web service and then use it when creating the SQL Server Connection object. The results will be that the MS Dynamics Database will then only return data that the connected user is authorized to view.</p> <p>This model is different from the standard model that consists of authenticating a given user for access to the web service. Instead, in my model everyone is granted access to the web service and the results of the SQL queries are based on the user name and password for a given user.</p> <p><strong>For Clarification:</strong> The Silverlight application collects the user name and password from the user when they log on to the application. This is the information that eventually needs to be used by the web service when the web service makes the connection to the SQL Server database. So my goal is to have the Silverlight applicaiton pass the username and password to the web service in such a way that the web service can retrieve it and use it when creating the Connection object.</p> <p>I'm considering something as simple as adding the user name and password to each web service request. However I'd rather be able to use the standard method for passing user credentials but I can't seem to find any way to get to the password. The user name is accessable throught the OperationContext.Current.ServiceSecurityContext.PrimaryIdentity.Name.</p> <p>Any ideas?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USLarry Welch
    1. USLarry Welch
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COYou should clarify what user name and password do you want to pass. Isn't access to CRM restricted only for Windows accounts? Is your Silverlight application accessed within intranet by domain users? Is user authenticated by his domain account in your service?
      singulars
      1. POWCF Web Service needs access to user name and password information
      1. USLadislav Mrnka
    2. COTo clarify - Bob Jones is logged into CRM. I need Bob Jones user name and password in the Web Service. The Web Service is hosted in the cloud and uses the user name and password to then create a connection to the database hosted on yet another server. Currently the web service uses a default user name and password to connect to the database and I want to use Bob Jones instead.
      singulars
      1. POWCF Web Service needs access to user name and password information
      1. USLarry Welch
    3. COIs Bob Jones Windows account? Btw. No build in security mechanism will get you password within operation processing. Do you need to create connection using SQL credentials or windows credentials?
      singulars
      1. POWCF Web Service needs access to user name and password information
      1. USLadislav Mrnka
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload