By micheld88 on

Hello.

In the beginning of my drupal site's life, I created node pages using the admin account. The problem is that if I want to edit them with my own account (which is not the admin one), I cannot (I have to be logged in with the admin user). So I want to know how to change the uid of a node page object to make it editable by another user than the original creator.
I tried to do SQL request like "update node set uid=xx where uid =1. It actually change the uid (my login is displayed at the top of the page with the creation date) but the Edit tab is not available so I cannot edit the page with my login.

Does anybody know how to do this ?

Thanks for help.
Michel.

Comments

kmv’s picture

kmv commented

Create a new role, give the role edit rights to nodes, then add your account to the new role.

cog.rusty’s picture

cog.rusty commented

That query is not enough. Many tables contain the old uid.

A solution is to login as user #1, edit the nodes, and change the author (user #1 can do that).

jdevries’s picture

jdevries commented

If the number of nodes that you want to change is not too big, you could also change the author by editing the node.

  1. Log in under your administrator account.
  2. Open the node you want to change author of, and edit it.
  3. Near the bottom is a group Authoring information where you can the author of the node.

edit: had I actually read a bit better, I would have seen that cog.rusty had already said the same thing. My bad...

micheld88’s picture

micheld88 commented

Many thanks for your responses. My problem is solved now.