[Building Sakai] How to create user using Sql Queries

[Jehan]

Thanks! problem resolved, it was realm entry missing.



On Mon, Jun 23, 2014 at 10:24 AM, Jehan <jeehaaan at gmail.com> wrote:

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