[turba] Global address book - user permisssions

/dustbin slash.dustbin at gmail.com
Fri Jun 16 00:17:48 PDT 2006


hello,

 i have configured horde and imp which is working fantastic and now want to
turba. I created two tables in mysql (horde DB), 1)turba_objects for storing
users personal address book n
 2)ga_book for storing the Global Address Book. this is my
turba/sources.php..

$cfgSources['localsql'] = array(
    'title' => _("My Personal Address Book"),
    'type' => 'sql',
    // The default connection details are pulled from the Horde-wide SQL
    // connection configuration.
    //
    // The old example illustrates how to use an alternate database
    // configuration.
    //
    // New Example:
    'params' => array_merge($conf['sql'], array('table' =>
'turba_objects')),

    // Old Example:
     'params' => array(
         'phptype' => 'mysql',
         'hostspec' => 'localhost',
         'username' => 'horde',
         'password' => 'xxxxxxxxx',
         'database' => 'horde',
         'table' => 'turba_objects',
         'charset' => 'iso-8859-1'
     ),
    'map' => array(
        '__key' => 'object_id',
        '__owner' => 'owner_id',
        '__type' => 'object_type',
        '__members' => 'object_members',
        '__uid' => 'object_uid',
        'name' => 'object_name',
        'email' => 'object_email',
        'alias' => 'object_alias',
        'homeAddress' => 'object_homeaddress',
        'workAddress' => 'object_workaddress',
        'homePhone' => 'object_homephone',
        'workPhone' => 'object_workphone',
        'cellPhone' => 'object_cellphone',
        'fax' => 'object_fax',
        'title' => 'object_title',
        'company' => 'object_company',
        'notes' => 'object_notes',
        'pgpPublicKey' => 'object_pgppublickey',
        'smimePublicKey' => 'object_smimepublickey',
        'freebusyUrl' => 'object_freebusyurl'
    ),
    'search' => array(
        'name',
        'email',
        'company'
    ),
    'strict' => array(
        'object_id',
        'owner_id',
        'object_type',
    ),
    'export' => false,
    'browse' => true,
    //'use_shares' => true,
    'public' => false,
    'readonly' => false,
     //'export' => true

);
$cfgSources['gadd'] = array(
    'title' => _("Global (Company) Addressbook"),
    'type' => 'sql',
    // The default connection details are pulled from the Horde-wide
    // SQL connection configuration.
    //
    // The old example illustrates how to use an alternate database
    // configuration.
    //
    // New Example:
    //'params' => array_merge($conf['sql'], array('table' => 'ga_book'),

    // Old Example:
     'params' => array(
         'phptype' => 'mysql',
         'hostspec' => 'localhost',
         'username' => 'horde',
         'password' => 'xxxxxxxxxxxxxx',
         'database' => 'horde',
         'table' => 'ga_book',
         'charset' => 'iso-8859-1'
     ),
    'map' => array(
        '__key' => 'object_id',
        '__owner' => 'owner_id',
        '__type' => 'object_type',
        '__members' => 'object_members',
        '__uid' => 'object_uid',
        'name' => 'object_name',
        'email' => 'object_email',
        'alias' => 'object_alias',
        'homeAddress' => 'object_homeaddress',
        'workAddress' => 'object_workaddress',
        'homePhone' => 'object_homephone',
        'workPhone' => 'object_workphone',
        'cellPhone' => 'object_cellphone',
        'fax' => 'object_fax',
        'title' => 'object_title',
        'company' => 'object_company',
        'notes' => 'object_notes',
        'pgpPublicKey' => 'object_pgppublickey',
        'smimePublicKey' => 'object_smimepublickey',
        'freebusyUrl' => 'object_freebusyurl'
    ),
    'search' => array(
        'name',
        'email',
        'company'
    ),
    'strict' => array(
        'object_id',
        'owner_id',
        'object_type',
    ),
    'public' => true,
    'readonly' => true,
    'admin' => array('admin at dustbin.com'),
    'export' => false
);


Version::
# Horde: 3.1.1
# Imp: H3 (4.0.3)
# Passwd: H3 (3.0)
# Turba: H3 (2.1.2-cvs)

Now i want the user admin at dustbin.com to be able to
add/modify/delete/imporrt the addresses in ga_book and the rest of users to
be able to browse the global address book.
But all the users can add/modify/delete/import in ga_book and also  when the
admin at dustbin.com imporrt the addrssses in ga_book tbe users can't browse
the field owner_id in ga_book is set to admin at dustbin.com n no one else has
permission to access..
is there's anybody come acrosss this ..
all the help highly apreciated..

please give some ideas regarding this.

t h a n k s
d u s t         b i n.


More information about the turba mailing list