Access control via a role based security model

I am trying to develop a web based database application to manage a Scout group. I need to control the level of access different visitors to the site are allowed to different parts of the database. I need to provide public information, including some contact details from the database, to

MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

I have run this command without Stating IN BOOLEAN MODE and my search goes fine. However this query returns a Syntax error WHEN IN BOOLEAN MODE OPTION IS ADDED , can anyone help ? Table is MyISAM type running on Linux 8.0 SELECT isbn, title, suggestedretail FROM bookscatalogue WHERE MATCH

RE: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

the only thing i could see a problem is the decimal but maybe not -Original Message- From: Francis Van-Lare [mailto:[EMAIL PROTECTED] Sent: Saturday, July 12, 2003 4:42 PM To: [EMAIL PROTECTED] Subject: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR I have run this command

RE: Access control via a role based security model

Hi You could achive what you want using grant statements, but you still need a user interface to send queries to the database and display the information sent back in a way that is manageble for non techies. There are many ways of building user interfaces, php ( http://www.php.net ) is probably

Searching Archives

Hi, I just joined this list and would like to search the archives before I ask a question. I there a way to search. Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: LIMIT question

Andrey [EMAIL PROTECTED] wrote: I have a following question: I have a table with thousands of rows which i need to show in a String Grid ( I use Borland Delphi with MyDac component which implements MySQL interface). If i make a query SELECT * FROM tbl WHERE col1=something, it can

Re: making all tables MyISAM

Neil Zanella [EMAIL PROTECTED] wrote: Is there a way to specify MyISAM for all tables in a given file rather than having to specify it at the end of each table declaration. I think this would make porting databases back and forth to MySQL somewhat easier since including MyISAM as part of

Re: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

Hi Your first statement looks ok to me but the one you have below has no space before AGAINST. Otherwise, I cannot see the problem myself. Mike - Original Message - From: Francis Van-Lare [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: July 12, 2003 2:42 AM Subject: MATCH AGAINST ()

Re: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

Francis Van-Lare [EMAIL PROTECTED] wrote: I have run this command without Stating IN BOOLEAN MODE and my search goes fine. However this query returns a Syntax error WHEN IN BOOLEAN MODE OPTION IS ADDED , can anyone help ? Table is MyISAM type running on Linux 8.0 SELECT isbn, title,

Re: Searching Archives

Ernest Pianalto [EMAIL PROTECTED] wrote: I just joined this list and would like to search the archives before I ask a question. I there a way to search. Here you can find list of searchable mailing list archives: http://www.mysql.com/documentation/lists.html -- For technical

RE: Access control via a role based security model

Thanks for the start Peter. I'm developing the interface using Tomcat and JSP. Tomcat http basis authentication provides a JDBC realm interface which allows me to use the content of my mySQL database to log users on, validate passwords and assign roles to them. I can see that it is feasible for

User Permissions

Can someone please help. I have MySQL for windows installed and I don't understand how to manage users. I have MySQL Control Center 0.8.10 Beta. The user I'm logged in as apparently doesn't have permissions to run DDL. I'm trying to take a dump of a remote db and run it here to install

mysql.sock

Hello all, after Installing mysql I started the mysql daemon.. The I tried to log in to my mysql database and got the message could not find mysql.sock in /tmp. In the mysql-configuration file /etc/my.cnf (in my redhat system 8.0) I changed the place for the socket file from

Mysql original database and GRANTS.

Hi All, I want to bring back my mysql original database as well as root GRANTS as was during the installation because i installed an application that modified my root GRANTS and now I am not able to see my mysql database as I login from root account. I am not even able to create or delete any

Could not start mysqld: bus error

Hi all I've been trying to build mysql 4.0.13 with linuxthreads on FreeBSD. The build process generates no error message and everything seems to be ok, but when I issue 'make test' it fails with the following message: cd mysql-test ; ./mysql-test-run Installing Test Databases Removing Stale

Stopping MySQL taking down a server?

This may be a silly question but what can be done to stop load-intensive MySQL processes taking down a server? Things like adding fulltext indexes to very large tables, or selects on very large (multi-million-row) tables just completely kill the box until they complete. I don't mind how long

Improving insertion performance by locking tables

Hello, We've got an application which does many multiple-value inserts to different tables. Is it worth locking a table before doing a multiple-value insert with say 50 records? If so, what is the number of records that makes it worthwhile? If not, is it worth locking a table before doing 2

FileMaker Pro

Does anyone know how to export a FileMaker Pro Database so that MySQL can use it? Anyone ever do something like this? Thanks, -- -Steve Marquez Marquez Design [EMAIL PROTECTED] www.marquez-design.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Stopping MySQL taking down a server?

In the last episode (Jul 12), Tim Fountain said: This may be a silly question but what can be done to stop load-intensive MySQL processes taking down a server? Things like adding fulltext indexes to very large tables, or selects on very large (multi-million-row) tables just completely kill the

Re: FileMaker Pro

FM is no problem. You can output from it to a tab-delimited file and then INSERT it into a mySQL DB. Or, a number of mySQL clients, including myPHPAdmin, allow you to import a text file, such as a tabbed file (or CSV, etc.). You must first set up your mySQL datatbase and be sure that the field

Extracting data from SQL Server *.DB file

I've read through the archives and spent hours on Google but I still can't figure this out. I must extract the data from a SQL Server *.DB file. Viewing the raw text, I can see that there views, grants, etc. at the top of the file, but this is a process that could not possible be done by hand.

Re: mysql.sock

Oliver Etzel - GoodnGo.COM (R) wrote: Hello all, after Installing mysql I started the mysql daemon.. The I tried to log in to my mysql database and got the message could not find mysql.sock in /tmp. In the mysql-configuration file /etc/my.cnf (in my redhat system 8.0) I changed the place for the

Re: Searching Archives

Hi Ernest, There are several ways to do it. Most pages like www.mysql.com or mirrors (geocrawler etc.) have a build in search function. http://lists.mysql.com/ (watch for the Archive links) http://lists.mysql.com/list.php?list=mysql#b (link for the general list - the one you are subscript to

select by weekly SUM

I have a table of daily information (tips, # of deliveries, etc.). Does anyone know of an easy way using SQL to extract all weekly sums of a field? Like: week 1: sum of tips for that week week 2: sum of tips for that week week 3: sum of tips for that week week 4: sum of tips for that week week

delete across multiple tables problem

I'm trying to help a friend with this. When I run this everything is fine SELECT * from clicks, urls WHERE clicks.url=urls.url AND urls.description IS NULL The clicks table has 31 instances of url that match 5 instances of url in the urls table. When I run the following I get a syntax error