[Building Sakai] RES: Removing users from sites directly via SQL

[Gabriel Slomka]

Yes, im tryng to integrate sakai with our academic system. We are removing
studants that change classes from theyr own classes, by scheduling SQL Jobs.
We compare databases so we know wich students are in the wrong classes
(sites). I know the ‘ideal’ would be to run this by sakai’s WebService, but
since we run this mostly in a SQLServer its not possible, or we would need
to create a specific service application that would do this.

 

  THanks alot for the attention !

 

De: Miguel Carro Pellicer [mailto:miguel at educlever.es] 
Enviada em: segunda-feira, 24 de março de 2014 10:01
Para: Gabriel Slomka; sakai-dev at collab.sakaiproject.org; 'Cleusa Sellin'
Assunto: Re: [Building Sakai] Removing users from sites directly via SQL

 

Hi Gabriel, i do not recommend to remove users directly from the
database.....

Why are you deleting them directly? Any specific objective or are you trying
to make some integration from external systems?

Miguel.

El 24/03/2014 12:45, Gabriel Slomka escribió:

Hello there Sakaiers.

 

   Im having a little issue on removing users from sites directly using
mysql code. I think this is kind of a simple question, yet im not being able
to solve it.

 

   Im tryng to remove users from sites deleting lines directly at
SAKAI_SITE_USERS table , however some users are still participants on theyr
websites, even if theyr deleted from this table. Is there any other place i
must delete the users so theyr totally removed from those sites ?

 

  Would apreciate any help. Thanks alot for the attention !

 

  Best Regards, Gabriel Slomka.






_______________________________________________
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"

 

-- 


Logo

Miguel Carro Pellicer
<http://es.linkedin.com/pub/miguel-carro-pellicer/38/502/b92> 
IT Consultant - Elearning solutions

Phone: +34 - 686266485
Email: miguel at educlever.es 


No me imprimas si no es necesario. Protejamos el medio ambiente


AVISO LEGAL: El contenido de este mensaje de correo electrónico, incluidos
los ficheros adjuntos, es confidencial y está protegido por el artículo 18.3
de la Constitución Española, que garantiza el secreto de las comunicaciones.

Si usted recibe este mensaje por error, por favor póngase en contacto con el
remitente para informarle de este hecho, y no difunda su contenido ni haga
copias. 
*** Este mensaje ha sido verificado con herramientas de eliminación de virus
y contenido malicioso *** 
Este aviso legal ha sido incorporado automáticamente al mensaje.

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140325/8c916d2a/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 8960 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140325/8c916d2a/attachment.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpeg
Size: 1103 bytes
Desc: not available
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140325/8c916d2a/attachment.jpe