[prev in list] [next in list] [prev in thread] [next in thread] 

List:       suse-slox-e
Subject:    AW: [suse-slox-e] WriteRights For Contacts
From:       "Steffen Jeschke" <sj () mandarin-medien ! de>
Date:       2004-03-30 12:49:43
Message-ID: !~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAAQzM4QJ7Rs0KQl60hIoJVY8KAAAAQAAAAT5w6EO2qrECWf2g+r7sBBgEAAAAA () mandarin-medien ! de
[Download RAW message or body]

Thank U very much or should i say "DANKE SCHÖN" :)

Now my team members and i are very happy, because we didn't do it manually!

Thanks alot Steffen Jeschke 

-----Ursprüngliche Nachricht-----
Von: Marcus Klein [mailto:m.klein@netline-is.de] 
Gesendet: Dienstag, 30. März 2004 12:15
An: suse-slox-e@suse.com
Betreff: Re: [suse-slox-e] WriteRights For Contacts

Okay,

first some explanations about the database design:

If I put something into these brackets "<...>" it is a tag and has to be
replaced.

Objects are stored in the tables named "prg_<object category>", e.g.
Contacts are stored in "prg_contacts". Read access is stored in "prg_<object
category>_read" and write access is stored in "prg_<object category>_mod",
e.g. read access for contacts is in "prg_contacts_read". Entries in these
tables are linked through the field intfield06 in prg_contacts and the field
object_id in prg_contacts_read and prg_contacts_mod. Additionally there is a
special field in "prg_<object category>" to find private and public entries
faster. This field is "group_right". There are three possible values: "a"
means public, "s" means private and "g" means some special rights defined in
_read and _mod.

Now a howto for copying a special right to contacts that are not public or
private:

First create a special contact that has a UNIQUE surename, maybe "ABCDE".
Set the read and write rights for this contact which you will apply to all
the other contacts. The following special SQL commands only work with
special rights that are not public or private.

Find the special created contact and its rights with:

SELECT intfield06 FROM prg_contacts WHERE field03 LIKE 'ABCDE';

You get the identification number for the applied rights.

Now apply these rights to all other contacts that are not public and not
private:

UPDATE prg_contacts SET intfield06 = <identification number> WHERE
group_right like 'g';

You get the number of contacts to which the new rights are applied. All your
contacts that are not public or private have now the same rights as the
special contacts with surename ABCDE.

If you have another special case for which you need a howto please tell it
to me.

Am Di 30.03.2004 11:33, Mrvka Andreas <mrv@tuev.at> schrieb:

> Am Die, den 30.03.2004 schrieb Marcus Klein um 10:23:
> > Sorry, that is not possible without hacking the database. With the
groupware frontend you have to edit all contacts.
> >
> > Are you familiar with SQL-Commands for databases? I can tell you some
SQL-Commands to achieve your wishes. But I might be dangerous.
> >
>
> but somebody is familiar to SQL-Commands and IS interessted in 
> changing multiple components in the database :o)
>
> i will be pleased to get some standard SQLs.
>
> regards
> Andrew

Best regards,

Marcus Klein
--
Netline Internet Service GmbH
Martinstraße 41
57462 Olpe

Email m.klein@netline-is.de


--
See the List-Unsubscribe header to unsubscribe For additional commands,
email: suse-slox-e-help@suse.com



-- 
See the List-Unsubscribe header to unsubscribe
For additional commands, email: suse-slox-e-help@suse.com


[prev in list] [next in list] [prev in thread] [next in thread]