Hi! <<Can I get Spectra to use an external database as a user directory where <<table names and field names are different from the Spectra defined field <<names? Theoretically "YES", because you can specify the way NETEGRITY looks at your data via -> C:\CFUSION\BIN\SmDsQuery.ini .... [UserDirectory] Query_Enumerate=select UserName as Name, 'User' as Class from Users Union select GroupName as Name, 'Group' as Class from Groups order by Class Query_InitUser=select UserName as Name from Users where UserName = '%s' Query_AuthenticateUser=select UserName as Name from Users where UserName = '%s' and Password = '%s' Query_GetGroups=select Groups.GroupName as Name from Groups, Users_Groups where Users_Groups.UserName = '%s' and Groups.GroupName = Users_Groups.GroupName Query_GetUserProp=select %s from Users where UserName = '%s' Query_SetUserProp=update Users set %s = %s where UserName = '%s' Query_GetObjInfo=select UserName as Name, 'User' from Users where UserName = '%s' Union select GroupName as Name, 'Group' from Groups where GroupName = '%s' Query_GetUserProps=UserName, Description Query_IsGroupMember=select GroupName from Users_Groups where UserName = '%s' and GroupName = '%s' .... Practically "NO", because Spectra-customtags use HARDCODED COLUMN-/TABLE-names ;-( If you're able/authorized to create a VIEW in your external database, you could establish a VIEW called "USERS" with two "columns" "USERNAME" / "PASSWORD". Regards, Peter Trumpp conceptware ag ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
