Question about userpermissions

  • I think I locked myself up as administrator ??
    I made a site for a small festival and filled in all the events/posts, categories etc. I did this as admin. Now I created a user, someone connected to the festival, who I want to be able to login and edit the texts from now on or create new posts.
    But his level is always lower than mine so he can’t edit my posts! The only way I can think of for now, is to give him my own login and password. But I don’t want that, because I want to keep controll over the database backups and so on and other possible mistakes.
    Solution?

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter Jack

    (@moxie)

    But what about the 50 posts I just made under level 10?

    use phpmyadmin to change the post_author of each post in the wp_posts table to the new author number.

    Hmm, yes, that’s logical. And I have played around with phpadmin for a while now, and I’m sure I would solve this on my ownies in time. But could you help me with the sql-syntax to get this done?
    SELECT * FROM ed2004_posts WHERE post_author=1
    and than what… ??

    Thread Starter Jack

    (@moxie)

    That was me again ??

    UPDATE ed2004_posts set post_author = ‘1’ where post_author = ‘[new author number]’;
    replace [new author number] with the new author number.

    Thread Starter Jack

    (@moxie)

    Thanks! And one more tiny question (and I know I have to go and RTFM, but I’m too tired right now, bedtime), but shouldn’t that be the other way around? Am I not ‘setting’ a new number ‘where’ the old number is 1?

    yea, sorry about that. i copied the statement from another post.
    corrected:
    UPDATE ed2004_posts set post_author = ‘[new author number]’ where post_author = ‘1’;

    Thread Starter Jack

    (@moxie)

    It worked (of course)! Thank you.

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Question about userpermissions’ is closed to new replies.