Set global permissions via phpMyAdmin

Moderators: mandville, PhilD, General Support Moderators

Locked
Aidan38
Joomla! Ace
Joomla! Ace
Posts: 1351
Joined: Mon Aug 06, 2012 8:51 am
Location: France Grenoble
Contact:

Set global permissions via phpMyAdmin

Post by Aidan38 » Tue Feb 12, 2013 10:54 pm

Hello,

I would like to know how can I set the permissions (located in Global Configuration => Permissions) via phpMyAdmin?
Wich table I have to edit/modify?

Thanks for your answers.
Books and tutorials about Joomla! http://cinnk.com
Create your online shop with Joomla! & HikaShop : http://cinnk.com/en/shop/create-your-on ... -paperback

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 25878
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Set global permissions via phpMyAdmin

Post by Per Yngve Berg » Wed Feb 13, 2013 7:07 am

The ACL entires are JSON encoded in the #__assets table for each element.

Aidan38
Joomla! Ace
Joomla! Ace
Posts: 1351
Joined: Mon Aug 06, 2012 8:51 am
Location: France Grenoble
Contact:

Re: Set global permissions via phpMyAdmin

Post by Aidan38 » Wed Feb 13, 2013 6:58 pm

Hello Per Yngve Berg,

thanks very much for this answer I have found what I was looking for ;)
Books and tutorials about Joomla! http://cinnk.com
Create your online shop with Joomla! & HikaShop : http://cinnk.com/en/shop/create-your-on ... -paperback

salehzand
Joomla! Fledgling
Joomla! Fledgling
Posts: 4
Joined: Thu Feb 02, 2012 2:22 pm

Re: Set global permissions via phpMyAdmin

Post by salehzand » Mon Apr 22, 2013 6:08 pm

Hi guys,

I followed your steps but I dont find the "Permissions" option in JSON encoded,
Do you know what is the name of the table /Column ?

User avatar
Per Yngve Berg
Joomla! Master
Joomla! Master
Posts: 25878
Joined: Mon Oct 27, 2008 9:27 pm
Location: Akershus, Norway

Re: Set global permissions via phpMyAdmin

Post by Per Yngve Berg » Mon Apr 22, 2013 7:27 pm

The "rules" column in the #_assets table.

Code: Select all

{"core.login.site":{"6":1,"2":1},"core.login.admin":{"6":1},"core.login.offline":{"6":1},"core.admin":{"8":1},"core.manage":{"7":1},"core.create":{"6":1,"3":1},"core.delete":{"6":1},"core.edit":{"6":1,"4":1},"core.edit.state":{"6":1,"5":1},"core.edit.own":{"6":1,"3":1}}


Locked

Return to “Access Control List (ACL) in Joomla! 2.5”