Marc, If it helps, the OBJECTDATA column is used in the standard security service to store any additional data that is placed in User.Perm. The extend-user-howto and Henning's DBSecurityService (fulcrum proposal) are all about adding actual columns for the additional data.
HTH, Scott -- Scott Eade Backstage Technologies Pty. Ltd. http://www.backstagetech.com.au > From: "Marc Lustig" <[EMAIL PROTECTED]> > Reply-To: "Turbine Users List" <[EMAIL PROTECTED]> > Date: Wed, 30 Oct 2002 14:10:33 +0100 > To: "Turbine Users List" <[EMAIL PROTECTED]> > Subject: AW: how to implement SecurityService proposal > > Hi, > > I need a bit more advise how to add columns to TURBINE_USER (or other > Security tables) using the SecurityService proposal. > I am confused by the following: > F:\cvs\jakarta-turbine-fulcrum\turbine-schema.xml says > ... > <column name="OBJECTDATA" type="VARBINARY"/> > @EXTRA_USER_COLUMNS@ > ... > > meaning that extra columns should be placed at that place. > But contridictary, db-security-service.html-howto suggests to create a new > table like this: > > <table name="CUSTOM_USER" idMethod="idbroker"> > <column name="USER_ID" required="true" primaryKey="true" > type="INTEGER"/> > <column name="LOGIN_NAME" required="true" size="64" type="VARCHAR" > javaName="UserName"/> > <column name="PASSWORD_VALUE" required="true" size="16" type="VARCHAR" > javaName="Password"/> > <column name="FIRST_NAME" required="true" size="64" type="VARCHAR"/> > <column name="LAST_NAME" required="true" size="64" type="VARCHAR"/> > <column name="EMAIL" size="64" type="VARCHAR"/> > <column name="CONFIRM_VALUE" size="16" type="VARCHAR" > javaName="Confirmed"/> > <column name="MODIFIED" type="TIMESTAMP"/> > <column name="CREATED" type="TIMESTAMP" javaName="CreateDate"/> > <column name="LAST_LOGIN" type="TIMESTAMP"/> > <column name="OBJECTDATA" type="VARBINARY"/> > > <column name="TELEPHONE" size="32" type="VARCHAR" javaName="Phone" /> > <column name="FAX" size="32" type="VARCHAR"/> > > <unique> > <unique-column name="LOGIN_NAME"/> > </unique> > </table> > > Which one is the correct way to add extra fields? > Keeping the standard table and just adding/removing fields? > Or adding a new table (to turbine-schema or project-schema ??) with a > different name? In this case, what to do with the standard-schema > "TURBINE_USER" ? Deleting? > > Thanks. > Marc > > > -- > To unsubscribe, e-mail: <mailto:turbine-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:turbine-user-help@;jakarta.apache.org> > -- To unsubscribe, e-mail: <mailto:turbine-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:turbine-user-help@;jakarta.apache.org>
