Hi Andrew, all!
[EMAIL PROTECTED] wrote:
[[...]] but I believe in security in depth and so for
read-only users I connect to the database with a SQL user that only has the
select privilege, and for read/write users I connect to the database with a
user with select,insert,update,delete privileg
[EMAIL PROTECTED] writes:
[...]
> Your application will still need access to the data it gets from
> MySQL so changing your MySQL permissions doesn't make any sense,
> does it. It's your application that needs to say "no" to the
> user. You don't want MySQL saying "no" to your application. Do you
[EMAIL PROTECTED] wrote on 10/12/2005 10:46:46 AM:
>
> You are correct in that each mysql user account only has one set of
> permissions. Your application talks to the database and it may only
> need one login. One login = one set of permissions. When I am
> designing a web-based application
>
> 10/12/2005 09:20 To
> AM[EMAIL PROTECTED]
> cc
> mysql@lists.mysql.com
> Subject
>Re: Downgrade privileges on
connect
>
>
>
]
cc
mysql@lists.mysql.com
Subject
Re: Downgrade privileges on connect
[EMAIL PROTECTED] writes:
> Is it possible for a MySQL connection to request a downgrade in
> privileges? What I'd like to be able to do is create one database
> user account for a database application with read and write
> privileges to the tables, but if an application user logs in who
> only h
[EMAIL PROTECTED] wrote on 10/12/2005 10:56:43 AM:
>
>
>
>
> Hello,
>
> Is it possible for a MySQL connection to request a downgrade in
privileges?
> What I'd like to be able to do is create one database user account for a
> database application with read and write privileges to the tables,
Hello,
Is it possible for a MySQL connection to request a downgrade in privileges?
What I'd like to be able to do is create one database user account for a
database application with read and write privileges to the tables, but if
an application user logs in who only has read access, then to do
