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>
index | next in thread | previous in thread | raw e-mail
[-- Attachment #1 --]
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 they
> 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.
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
--
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
[-- Attachment #2 --]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (FreeBSD)
iD8DBQFAcSFGdtESqEQa7a0RAv2sAJ98uaBmG4WrCiBdFJSjlcGgaDVdXwCdFiEM
OyzrsyQOmBR85kOj/cevVNA=
=8mBH
-----END PGP SIGNATURE-----
home |
help
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040405090510.GA56728>