RE: [eGroupWare-users] EGW Wiki: SQL Script to change modify/view permission?

[Pete <pe...@pa...>]

Thanks Ralf, this help greatly.

But it has thrown up two new issues (please assume that I have a user U
who belongs to group G and that only a few wiki pages allow read/write
access to group G):

- if user U adds a new page, the new page is by default accessible by
everyone (i.e. user U must change access manually and thereby can see
all groups and possibly select the wrong one which would mean that he
can't see that page he added). Can this be changed?

- I noticed that for user U, the link "Recent Changes" at the top of
each wiki page appears as "Reacent Changes?" with the ? hyperlinked like
for new pages. Is there a way to enable recent changes for user U such
that he can see a list which includes only wiki documents accessible by
him?

Thanks
Pete

> Ralf wrote:
>
> there's no sql scripts - thought you can do so quite easy in SQL:
> 
> UPDATE phpgw_wiki_pages
> SET wiki_readable=<uid of everyone>,
> wiki_writable=<uid of everyone>
> 
> You need to find out the uid of the group everyone before.
> 
> Ralf
> 
> Peter Hug schrieb:
> > We have many wiki pages, all of which are accessible to 
> "everyone". We 
> > have now added a few wiki pages (public) we'd like to share with 
> > outsiders. I have created a new user group and added all users who 
> > have a right to view/modify these public pages and set the 
> modify/view 
> > permissions in these public pages accordingly.
> > 
> > The problem I now have is that these people can view all other wiki 
> > pages too because they are accessible by everyone.
> > 
> > I wonder if there is an SQL script that I could run on the 
> EGW MySQL 
> > db to change access to all wiki pages availabe to 
> "everyone" so that 
> > they are only available to a specific group?
> > 
> > Pete
> > 
> > 
> > 
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from real 
> > users. Discover which products truly live up to the hype. Start 
> > reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> > _______________________________________________
> > eGroupWare-users mailing list eGr...@li...
> > https://lists.sourceforge.net/lists/listinfo/egroupware-users
> 
> -- 
> eGroupWare Training ==> http://www.outdoor-training.de/egroupware
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from 
> real users. Discover which products truly live up to the 
> hype. Start reading now. 
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396> &op=click
> 
> _______________________________________________
> 
> eGroupWare-users mailing list eGr...@li...
> https://lists.sourceforge.net/lists/listinfo/egroupware-users
> 
>