Last post Aug 25, 2011 01:53 PM by Lannie
Aug 23, 2011 10:17 PM|NoBullMan|LINK
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.?
Aug 24, 2011 02:12 PM|Lannie|LINK
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.
Aug 24, 2011 03:41 PM|NoBullMan|LINK
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?
Aug 25, 2011 01:53 PM|Lannie|LINK
sometimes some minor modification of the queries and ODP.NET code is required as there are some minor differences between Oracle and MSSQL.
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.