Forgot to mention that using <cflogin> and <cfloginuser> also give you access to the function #getAuthUser()# which will return the authenticated username at any time. This is in addition to the #isUserInRole()# function. Both are pretty handy. If you are not using MX yet, this could be a good time to upgrade.
Cantrell On Tuesday, December 3, 2002, at 07:02 AM, Ian Vaughan wrote: > I have been informed that user roles and groups for users is the best > approach but how does this exactly work from a Coldfusion > persepective, and > is this the best way to achieve my brief, or is the way I am planning > on > going the best approach? > > This is my brief, I am creating an Intranet application that features a > publishing area allowing users to add/delete/modify their own content > on the > site. Using html forms, CFFile and Oracle to hold word and pdf docs. > And > having a select form field where the user selects who should see the > file > teama, teamb or everybody > > However some users of the Intranet are from teama and should only be > allowed > to view documents related to teama. teamb have documents that only > their > team should see. Finally there will be some documents that users > upload > that are available to everybody. > > To access the Intranet the users have to log in, where their username > and > password is authenticated against the user table. The user table has > fields.. > > id > username > password > fname > lname > division > > If correct they enter the intranet. The click on the documents link > where > the following query would be run, I was thinking along the lines of > adding a > where clause perhaps ? using the info where the user selected when > they > added the content - i.e. should it be see by teama, teamb or everybody? > > Is this the best way to achieve this ???? > > <CFQUERY name="docs" datasource="intranetv8"> > SELECT docid, doctitle, docsummary, docpath, views > FROM itdocs > WHERE category2='#URL.category2#' > AND > views='#what would go here that states what result of docs would be > shown > based on the user logged in. If the doc is only to be viewed by teama, > teamb or everybody???#' > </CFQUERY> > > > > ian > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
