Date: Mon, 5 Apr 2004 10:05:10 +0100 From: Matthew Seaman <m.seaman@infracaninophile.co.uk> To: Noah <admin2@enabled.com> Cc: freebsd-questions@freebsd.org Subject: Re: phpmyadmin - users not seeing specific database Message-ID: <20040405090510.GA56728@happy-idiot-talk.infracaninophile.co.uk> In-Reply-To: <20040405081454.M1983@enabled.com> References: <20040405081454.M1983@enabled.com>
next in thread | previous in thread | raw e-mail | index | archive | help
--OXfL5xGRrasGEqWY
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
On Mon, Apr 05, 2004 at 12:21:59AM -0800, Noah wrote:
> I set the $cfg['Servers'][$i]['auth_type'] to cookie so users definitely =
get
> the login. but when I login with a user other than root. I find that I =
am
> able to veiw all the databases that root could view. I was assuming with=
the
> multiuser functionality that users could only view databases for which th=
ey
> have granted access to. is there something else i need to configure here?
Well, the 'cookie' mode just exposes the internal mysql authentication
and access control via the web. Works very well for me. =20
Can you verify that your users have the correct privilege GRANTs
within the database -- ie. specifically can you use mysql(1)'s command
line to log in as those users and access bits of the database you
shouldn't be able to?
Cheers,
Matthew
--=20
Dr Matthew J Seaman MA, D.Phil. 26 The Paddocks
Savill Way
PGP: http://www.infracaninophile.co.uk/pgpkey Marlow
Tel: +44 1628 476614 Bucks., SL7 1TH UK
--OXfL5xGRrasGEqWY
Content-Type: application/pgp-signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (FreeBSD)
iD8DBQFAcSFGdtESqEQa7a0RAv2sAJ98uaBmG4WrCiBdFJSjlcGgaDVdXwCdFiEM
OyzrsyQOmBR85kOj/cevVNA=
=8mBH
-----END PGP SIGNATURE-----
--OXfL5xGRrasGEqWY--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040405090510.GA56728>