Hi All,
I'm writing a application that needs row level security in it so that
only certain users can view/change etc. certain records. I know that
MySQL currently does not have row level security, and when I've asked
this list before I've been given some helpfull suggestions (although
none of
So if below is actually what your data looks like, what about:
Select Field1, Field2, MAX(IDField) From MyTable Group by Field1
That might get the correct answer for you, but it does however have an extra
field in the result (which may or may not be a problem).
cheers,
noel
filter word:mysql
changes so that mysql
rereads the grant tables.
If you can give us the exact line(s) you're putting in then that could help
us see the problem (change/mask the password of course).
cheers,
noel
On Tuesday, May 07, 2002 1:44 PM, Noel Clarkson
[SMTP:[EMAIL PROTECTED]] wrote:
> See that li
See that line that says accept any user (%) from any host (%) with password
null. There's your answer. It's a default entry that should be removed (I
think there's stuff in the securing mysql section of the manual about
this).
cheers
noel
On Tuesday, May 07, 2002 1:28 PM, Brandon Metcalf
Hi Son,
On Monday, April 08, 2002 2:37 PM, Son Nguyen [SMTP:[EMAIL PROTECTED]]
wrote:
>
> --- BD <[EMAIL PROTECTED]> wrote:
> > Son,
> >
> > At 09:48 PM 4/7/2002, you wrote:
> > >mysql> desc threads;
> >
> >+-+--+--+-+-++
> > >| Field
Hi there,
the other comments may have got you where you want but as no one had
mentioned your final option thought I'd mention (from /h at the mysql
command line)
source (\.)Execute a SQL script file. Takes a file name as an
argument.
so you can run the script from the mysql prompt.
ch
Thanks Arjen,
seems like a bit of a fiddle but not a bad solution considering some of the
other options. Unfortunately I also need the row level locking of innodb
so it's not going to work in my case. This lead me to ponder, if this
sort of row level protection was added would it be at the
Hi all,
I'm wondering about row level privilages - being able to restrict what
people see and can update etc on a row level as well as a column/table
level.
I know that I can implement it in my program (which is what I'm currently
doing) but unless it's in the backend db then every program tha
You don't want to use LIKE in mysql - or have you not read about LIKE in
the fine mysql manual??
If you use LIKE you will also need to use a % sign signify which bit is the
variable bit. This is because mysql allows you to say if the variable bit
is at the start or the end or both. LIKE 'ban
Hi there,
My understanding is that there is no BOOL type in MySQL but BOOL is allowed
in create table statements (or alter table etc) for compatibility with
other databases (but MySQL uses a tinyint for a bool because it doesn't
have bool).
You can use a tinyint and say that 0 is false 1 is t
Ok so
SELECT * FROM Events, Djs, EventDjs WHERE Events.eventID = EventDjs.eventID
AND Djs.DJID = EventDjs.DJID;
should give you a list with the event and the dj etc, if you only want one
event then add something like AND Events.Events.eventID = 'x' or whatever.
cheers,
noel
On Tuesday, July
> >
> >interestingly, if I type sh I get 'show ' but if I type show
ta I
> >don't get 'show tables' which is what I would expect.
>
> Does "show tables" actually produce a list of tables, or no tables?
> On some systems, there is a bug in glibc that prevents it from working
> properly, in which
how ' but if I type show ta I
don't get 'show tables' which is what I would expect.
If there is anything else that I can provide to help sort this out I'd be
only too happy to.
cheers,
noel
On Friday, July 13, 2001 9:59 PM, Sinisa Milivojevic
[SMTP:[EMAIL PROTECTED]]
Didn't see a response to this so here's some ideas.
You can do an INSERT INTO tablename SELECT ... statement or if you are
creating a new table to put these values into CREATE TABLE tablename
(SELECT ...). Check the manual for the exact syntax and for which version
of mysql you'll need for th
Hi all,
When using the 3.23.39 client to connect to the server, pressing tab to
complete table names and field names etc doesn't seem to work. I seem to
get the mysql commands, but I thought in past clients I was able to get
table name and field name completion as well.
Have others noticed t
Wouldn't that depend on if the MySQL db is on the same server as the web
servers and the scripts that connect to them. It could also depend on if
the scripts use the -h option when making a connection and if this is the
ip address (as in number) or is a resolvable name. If it is all local, if
How are you updating in delphi and what is the error?
if you are running a query, setting the edit state and request live (either
at design or run time) and then updating the data and it complains that
someone else has changed the record then check the TQuery settings, there
is one that determ
I read the comments on NuSphere in the portals section:
"As long as GEMINI is not released under open source, as required by the
GPL license of the MySQL server, we at MySQL AB can't recommend anyone to
use this distribution."
and I'm left thinking they are in violation of the GPL. If this is
Hi there,
I'm using MaxSQL 3.23.39 and have set up an innodb table but when I run an
update statement the timestamp field does not update automatically. Is
anyone else experiencing this, or is it an expected behaviour of innodb
tables? I couldn't find anything in the manual saying that this
I don't know about MySQL 3.22.32 but in 3.23.27 if you create a table with
a primary key of two fields, one of which is an auto increment field then
you will get the behaviour you are looking for (ie the auto inc will start
at 1 for each different value in the other field). I don't have 3.22.x
I've done it on a 486 with 64Mb memory and it took about an hour or an hour
and a half or so (it was a long time and I went off and did other things
while it was happening so my timing is not precise (oh that's make time for
the main part, make install much quicker) - and it was a few versions
Hi all,
I'm wanting to set up mysql to run in a chroot jail. I saw the command
line option --chroot and tried this which seemed to work (well mysql ran
anyway). I added this to the startup script (running redhat 7.0) in
/etc/rc.d/init.d/mysql so that it would use this option (and because I n
22 matches
Mail list logo
