From: Rodrigo C. <gr...@ca...> - 2004-06-21 10:59:43
|
I am in problemns with this. I have a user that have acess only for the = database "mirror" but when he logs in pgadmin no database is showed. Accessing via psql the user have normal acess, the problem is only in = pgadmin. When I log in with a "super user" account everything is ok. In my config.inc I configured the parameter $conf['owned_only'] = =3D true; My config.inc is as below: Any suggestion??? <?php /** * Central phpPgAdmin configuration. As a user you may modify = the * settings here for your particular configuration. * * $Id: config.inc.php-dist,v 1.34 2004/05/08 14:45:10 chriskl = Exp $ */ // An example server. Create as many of these as you wish, // indexed from zero upwards. // Display name for the server on the login screen $conf['servers'][0]['desc'] =3D 'PostgreSQL - Carbono'; // Hostname or IP address for server. Use '' for UNIX domain = socket. $conf['servers'][0]['host'] =3D '192.168.0.50'; // Database port on server (5432 is the PostgreSQL default) $conf['servers'][0]['port'] =3D 5432; // Change the default database only if you cannot connect to = template1 $conf['servers'][0]['defaultdb'] =3D 'template1'; // Specify the path to the database dump utilities for this = server. // You can set these to '' if no dumper is available. $conf['servers'][0]['pg_dump_path'] =3D '/usr/bin/pg_dump'; $conf['servers'][0]['pg_dumpall_path'] =3D = '/usr/bin/pg_dumpall'; // Example for a second server //$conf['servers'][1]['desc'] =3D 'Test Server'; //$conf['servers'][1]['host'] =3D '192.168.0.1'; //$conf['servers'][1]['port'] =3D 5432; //$conf['servers'][1]['defaultdb'] =3D 'template1'; //$conf['servers'][1]['pg_dump_path'] =3D = 'c:/cygwin/bin/pg_dump.exe'; //$conf['servers'][1]['pg_dumpall_path'] =3D ''; // Default language setting. eg 'english', 'polish', etc. $conf['default_lang'] =3D 'portuguese-br'; // If extra login security is true, then logins via phpPgAdmin = with no // password or certain usernames (pgsql, postgres, root, = administrator) // will be denied. Only set this false once you have read the FAQ and // understand how to change PostgreSQL's pg_hba.conf to enable // passworded local connections. $conf['extra_login_security'] =3D true; // Only show owned databases? // Note: This will simply hide other databases in the list - = this does // not in any way prevent your users from seeing other database = by // other means. (eg. Run 'SELECT * FROM pg_database' in the SQL = area.) $conf['owned_only'] =3D true; // Display comments on objects? Comments are a good way of = documenting // a database, but they do take up space in the interface. $conf['show_comments'] =3D true; // Display "advanced" objects? Setting this to true will show = types, // operators conversions, languages and casts in phpPgAdmin. = These // objects are rarely administered and can clutter the = interface. $conf['show_advanced'] =3D false; // Display "system" objects? $conf['show_system'] =3D false; // Display reports feature? For this feature to work, you must // install the reports database as explained in the INSTALL = file. $conf['show_reports'] =3D true; // Only show owned reports? // Note: This does not prevent people from accessing other = reports by // other means. $conf['owned_reports_only'] =3D false; // Minimum length users can set their password to. $conf['min_password_length'] =3D 1; // Width of the left frame in pixels (object browser) $conf['left_width'] =3D 200; // Which look & feel theme to use $conf['theme'] =3D 'default'; // Show OIDs when browsing tables? $conf['show_oids'] =3D false; // Max rows to show on a page when browsing record sets $conf['max_rows'] =3D 30; // Max chars of each field to display by default in browse mode $conf['max_chars'] =3D 50; // Send XHTML headers? Unless debugging, it's best to leave = this off $conf['use_xhtml'] =3D false; /***************************************** * Don't modify anything below this line * *****************************************/ $conf['version'] =3D 13; ?> Att. Rodrigo Carvalhaes ************************************************ Carvalhaes Produtos para Laborat=F3rio Ltda. Fone: +55 (51) 483-88-40 / Fax : +55 (51) 483-88-39 Estrada C=E2ndido Pinheiro de Barcelos, 2332 - Distrito Industrial=20 Alvorada - RS - Brasil - Cep 94836-010=20 Visite nosso site: www.carvalhaes.net=20 |