Row level security in MySQL

2004-05-11 Thread Sagar, Sanjeev
Hello All, I have a requirement where I have to implement the Oracle fine grain access control functionality in MySQL 4.0.19 Any ideas will be highly appreciable that how can I implement this in MySQL. I know how to do it in Oracle but not sure if MySQL can do this. For details about Oracle

Re: Row level security in MySQL

2004-05-11 Thread Paul DuBois
At 10:16 -0500 5/11/04, Sagar, Sanjeev wrote: Hello All, I have a requirement where I have to implement the Oracle fine grain access control functionality in MySQL 4.0.19 Any ideas will be highly appreciable that how can I implement this in MySQL. I know how to do it in Oracle but not sure if

FW: Row level security in MySQL

2004-05-11 Thread Sagar, Sanjeev
Thanks ! -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 10:28 AM To: Sagar, Sanjeev; [EMAIL PROTECTED] Subject: Re: Row level security in MySQL At 10:16 -0500 5/11/04, Sagar, Sanjeev wrote: Hello All, I have a requirement where I have

Re: Row level security in MySQL

2004-05-11 Thread Alec . Cawley
Sagar, Sanjeev [EMAIL PROTECTED] wrote on 11/05/2004 16:16:19: Hello All, I have a requirement where I have to implement the Oracle fine grain access control functionality in MySQL 4.0.19 Any ideas will be highly appreciable that how can I implement this in MySQL. I know how to do

RE: The Security of MySQL

2003-02-28 Thread Dyego Souza do Carmo
Respondendo, quinta-feira, 27 de fevereiro de 2003, 13:32:39, Mensagem Original: AN Are you using Windows? If so, this root/mysql user talk will be AN meaningless. You can still make the directory secure and only touchable AN by the user that mysql is running as. Is this what you need? nope ,

Re: The Security of MySQL

2003-02-27 Thread Fred van Engen
Hi Dyego, On Wed, Feb 26, 2003 at 04:04:36PM -0300, Dyego Souza do Carmo wrote: MM You should use the filesystem security your operating system provides to MM prevent common users from copying the database files. The directory that MM the database files resides in only needs to allow access

RE: The Security of MySQL

2003-02-27 Thread Adam Nelson
: Wednesday, February 26, 2003 12:13 PM To: [EMAIL PROTECTED] Subject: The Security of MySQL I'm using MySQL-Pro+InnoDB 4.0.11 and i have a BIG problem... My users is hacking the database because the MySQL system tables are stored in .MYD format and to hack database is simple , only rename

The Security of MySQL

2003-02-26 Thread Dyego Souza do Carmo
MySQL-Team and users... The security of MySQL is too simple ? only rename and the database is opened for world ? please help in advance ;) Tanks Tanks very much sql,query,innodb,mysql - ++ Dyego Souza

Re: The Security of MySQL

2003-02-26 Thread Mark Matthews
TABLE STATEMENT but i'm using and is same without the clause. Please MySQL-Team and users... The security of MySQL is too simple ? only rename and the database is opened for world ? please help in advance ;) You should use the filesystem security your operating system provides to prevent common users

RE: The Security of MySQL

2003-02-26 Thread John Griffin
] Subject: The Security of MySQL I'm using MySQL-Pro+InnoDB 4.0.11 and i have a BIG problem... My users is hacking the database because the MySQL system tables are stored in .MYD format and to hack database is simple , only rename the database and copy the blank database... restart MySQL

Re: The Security of MySQL

2003-02-26 Thread Manuel Kiessling
Dyego Souza do Carmo wrote: Tanks Tanks very much uh, we have war already?? (sorry couldn't resist) -- Manuel Kiessling sql,query,innodb,mysql - Before posting, please check: http://www.mysql.com/manual.php

Re: The Security of MySQL

2003-02-26 Thread gerald_clark
( IN CLEAR TEXT) and this is terrible for me ! Exists the PASSWORD on CREATE TABLE STATEMENT but i'm using and is same without the clause. Please MySQL-Team and users... The security of MySQL is too simple ? only rename and the database is opened for world ? please help in advance ;) Tanks

Re[2]: The Security of MySQL

2003-02-26 Thread Dyego Souza do Carmo
the clause. JT Please MySQL-Team and users... The security of MySQL is too simple ? JT only rename and the database is opened for world ? JT please help in advance ;) JT Tanks JT Tanks very much - ++ Dyego Souza

Re: The Security of MySQL

2003-02-26 Thread Dyego Souza do Carmo
MM You should use the filesystem security your operating system provides to MM prevent common users from copying the database files. The directory that MM the database files resides in only needs to allow access by the user MM that the MySQL server is running as. If you do this, only users who

Re: The Security of MySQL

2003-02-26 Thread gerald_clark
I your customers have root access to their machine, then there is no security, nor can there be. Dyego Souza do Carmo wrote: MM You should use the filesystem security your operating system provides to MM prevent common users from copying the database files. The directory that MM the database

RE: Re[2]: The Security of MySQL

2003-02-26 Thread John Griffin
, February 26, 2003 1:58 PM To: Jeremy Tinley Cc: [EMAIL PROTECTED] Subject: Re[2]: The Security of MySQL Respondendo, quarta-feira, 26 de fevereiro de 2003, 14:46:45, Mensagem Original: JT Why does a user on your system have access to rename the database? Your JT database files should be readable

SV: Security of MySQL

2001-11-21 Thread Torgil Zechel
Chapter 4 in the manual is a good place to start! http://www.mysql.com/doc/M/y/MySQL_Database_Administration.html -Ursprungligt meddelande- Fran: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Skickat: den 21 november 2001 09:55 Till: [EMAIL PROTECTED] Amne: Security of MySQL Hello, My