turbine-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Hughes <mhu...@uvic.ca>
Subject Re: inserting user into mysql for use with turbine security
Date Wed, 14 Jan 2004 17:11:29 GMT
Chris Joelly wrote:
> Hello!
> 
> i want to insert/update an user from within my application for use with
> turbine security. i looked at the datamodel and have inserted the user
> with the following statements into TURBINE_USER and TURBINE_USER_GROUP_ROLE
> 
> 
> insert into TURBINE_USER (USER_ID, LOGIN_NAME, PASSWORD_VALUE, FIRST_NAME, LAST_NAME)
> 	values (1001, 'portal', 'portal', 'APortal', 'User');
> 	
> insert into TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID, ROLE_ID)
> 	values (1001, 1, 2);
> 
> are there any other tables to set? the group and role used in this
> example does exist, but i can't login with this user ...
> 
> thx, Chris
> 

I found that I had to add new users to the turbine_root role (number 1) 
before they could log in to the app. Not sure why this is.

insert into TURBINE_USER_GROUP_ROLE (USER_ID, GROUP_ID, ROLE_ID)
  	values (1001, 1, 1);

-- 
  Matt Hughes
   + mhughe@uvic.ca
   + http://spacemonkeys.ca/

---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-user-help@jakarta.apache.org


Mime
View raw message