Re: Row level security in MySQL

[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 it in Oracle but not sure if MySQL can do this.

Use the InnoDB table type, which is closely modelled on Oracle structurea
and has row-level locking.

  Alec


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

FW: Row level security in MySQL

[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 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.

It cannot. You must implement this in your application.



-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Row level security in MySQL

[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 MySQL can do this.
It cannot. You must implement this in your application.



--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Row level security in MySQL

[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 fine grain access or row level security, see below
mention link

http://www.unix.org.ua/orelly/oracle/guide8i/ch08_01.htm
 


Best Regards,



 <> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]