Hi all,
what are the privileges required for a normal user X to be able to use the bookmark features?
I added select, insert, update, delete, index, alter to this user X for database bookmark, table bookmark, and he does not see the bookmarks.
However a user A with global privileges was able to create bookmarks on the database X.
User X, in mysql, can see the bookmarks.
I think that your config.inc.php look like this :
$cfgServers[1]['host'] = 'localhost'; $cfgServers[1]['port'] = ''; $cfgServers[1]['adv_auth'] = true; $cfgServers[1]['stduser'] = 'xxxx'; $cfgServers[1]['stdpass'] = 'yyyy'; $cfgServers[1]['user'] = ''; $cfgServers[1]['password'] = ''; $cfgServers[1]['only_db'] = ''; $cfgServers[1]['verbose'] = ''; $cfgServers[1]['bookmarkdb'] = 'bookmarkdb'; $cfgServers[1]['bookmarktable'] = 'bookmarktable';
This not work :(
If you want to use bookmark in adv_auth for others users, you must add a new $cfgServer section :
$cfgServers[2]['host'] = 'localhost'; $cfgServers[2]['port'] = ''; $cfgServers[2]['adv_auth'] = true; $cfgServers[2]['stduser'] = 'anotheruser'; $cfgServers[2]['stdpass'] = 'anotherpass'; $cfgServers[2]['user'] = ''; $cfgServers[2]['password'] = ''; $cfgServers[2]['only_db'] = ''; $cfgServers[2]['verbose'] = ''; $cfgServers[2]['bookmarkdb'] = 'bookmarkdb'; $cfgServers[2]['bookmarktable'] = 'bookmarktable';
Yes, it's not perfect :( But, because of security, i think it's much better (all users don't share the same bookmark table). If you are another idea, i'm opened :)
Yours. ................................................................ Webmaster PHPIndex http://www.phpindex.com webmaster@phpindex.com ................................................................