Le roy Arnaud wrote: > Yes but it's more quickly to do a select on index (PKID in users table) > than a full scan on usersinroles
I think that presume users table isn't good. What about create column with some (SHA1) hash. It not at all good solution, but will be easy to implement and use. Maybe somebody bring some hint. >>(i.e. if users table will be in another DB) and probably problem > > I think that the asp .net provider must be in the same database I don't think so. If you provide different connectionStringName for each provider, you can use whatever you want. Also using different providers is allowed, so ... >>(what if admin will use hardcoded users in code). > > I'm not sure to understand can you send an exemple ? Somebody can i.e. in OnAuthenticate perform all actions by hand. And this maybe brings some problems. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider