[Building Sakai] How to create user using Sql Queries

[Jehan]

Dear Metthew Jhones!

Yes! I want to create new tool for some users who will create new user
accounts only.

Yes! I am using UserDirectoryService.

New tool is added to a project site, and that user  i.g., "DAVID" is added with
maintain role.


When "DAVID" attempt to create new user  then face permission/security
exception. I don't want to give access of  !admin (Administrator Workspace)
to that user.

How to resolve permission exception.

Thanks



On Mon, Jun 23, 2014 at 8:50 AM, Steve Swinsburg <steve.swinsburg at gmail.com>
wrote:

> 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/46659bfc/attachment.html