[Building Sakai] How to create user using Sql Queries

[Steve Swinsburg]

As others have suggested, use the api.

Rule of thumb: unless your tool owns the database tables, dont touch them
with SQL.

You can wrap the api calls with session escalation if required. Know what
you are doing before you do that though, and how to cleanup.

Cheers
Steve

sent from my mobile device
On 21/06/2014 3:09 PM, "Jehan" <jeehaaan at gmail.com> wrote:

>  Dear Johan
>
> I want to create a new tool for user creation and password resetting, that
> tool permission will be given to an academic assistant, who will be able to
> change password and create new user  of his department only, we cannot give
> him admin rights/realm, and without admin rights webservices gives
> permission exception while creating new user.
>
> Can you help.
>
>
>
> On Fri, Jun 20, 2014 at 8:06 PM, John Bush <jbush at anisakai.com> wrote:
>
>> yes but I think it would be several sql calls, but its the wrong way
>> to do it,  so I'm not going to give you any details to shoot yourself
>> in the foot with.
>>
>> On Fri, Jun 20, 2014 at 3:06 AM, Jehan <jeehaaan at gmail.com> wrote:
>> > Dear All
>> >
>> >
>> > Is it possible to create new user using Sql Query instead of using
>> > web-service call.
>> >
>> > Thanks
>> >
>> > _______________________________________________
>> > sakai-dev mailing list
>> > sakai-dev at collab.sakaiproject.org
>> > http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>> >
>> > TO UNSUBSCRIBE: send email to
>> sakai-dev-unsubscribe at collab.sakaiproject.org
>> > with a subject of "unsubscribe"
>>
>>
>>
>> --
>> John Bush
>> 602-490-0470
>>
>> ** This message is neither private nor confidential in fact the US
>> government is storing it in a warehouse located in Utah for future
>> data mining use cases should they arise. **
>>
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140623/b81780a1/attachment.html