asp.net app + Oracle + Win Authentcation

Question

User-39953368 posted

Hi,

I have donea bunch of apps with asp.net and SQL sever but now I have to do one using Oracle (11g) in conjunction with Windows authentication (an Intranet app). Can someone point me  in the right direction on how this can be accomplished (articles, How-Tos, ...), speifying prviders, etc.?

Thanks.

Answer 1

User269602965 posted

Forms authentication against the OS users you put into an application group

to control their privileges.

One step further is roles for app users

and use the role for privileges.

Pretty much in the same in Oracle as it is in MSSQL.

http://download.oracle.com/docs/cd/E11882_01/win.112/e18737.pdf

Answer 2

User-39953368 posted

Thanks Lannie. Is Windows authentication handles the same way? Do I need anythingelse aside from specifying authentication type in config file and setting up IIS properly?

Answer 3

User269602965 posted

sometimes some minor modification of the queries and ODP.NET code is required as there are some minor differences between Oracle and MSSQL.

For example

WHERE MYKEY = :MYKEY

Oracle used COLON symbol for the bind parameter designation.

Intellitype in the .net code section usually helps with some Oracle ODP.NET specific ways of doing things.

You might need some examples to get more acquainted.

http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10767.pdf