> Better add "SQL SECURITY DEFINER" to it.
I noticed that it works with and without this. I have added it to the
procedure.
Another quick question though. Since I have added the end user that
will execute the procedure it works fine, until I drop the procedure and
recreate it then I have to rea
On 2007-02-28 Gary W. Smith wrote:
...
> If I'm understanding the docs correct (which I'm probably not), I should
> create the procedure with [EMAIL PROTECTED]
>
> CREATE [EMAIL PROTECTED] PROCEDURE
Better add "SQL SECURITY DEFINER" to it.
..
> The next question is what permissions do I need t
> The next question is what permissions do I need to give
> [EMAIL PROTECTED] to just access that one permission?
The sound of that thump thump thump is my head hitting the wall.
There is like a single small line in the GRANT section of the how to
that mentioned "TABLE|PROCEDURE|FUNCTIO" but none
> Do you know about the "SQL SECURITY { DEFINER | INVOKER }" options to
> CREATE PROCEDURE? With them it should be possible to
> * deny selects to users on the tables
> * allow selects to users to this procedure
> * having the procedure itself working with the rights of root/definer
I did not, but
On 2007-02-28 Gary W. Smith wrote:
> Basically, here is the stored proc. It works, but only for root. Is it
> possible to allow user to execute this without having SELECT access to
> the table users? If so, how?
Do you know about the "SQL SECURITY { DEFINER | INVOKER }" options to
CREATE PRO
I have a set of tables that contain sensitive user information. I need
to use this data for validation BUT I don't want the end user to have
access to read this data. In MSSQL I used to be able to create a stored
proc to do the work (even though the user didn't have access to the
table). I was w
Hi All,
I'm learning mysql among other programs to put together a web page with
database in the background. My first goal is to simply produce a crude
example for demo purposes, it can be refined a great deal later. I've
set up a small mysql data base on a commercial web hosting server. It
p
At 20:27 -0700 3/14/02, Mike Hillyer wrote:
>I am trying to make a database system in MYSQL, but I need to restrict
>access to certain records in a table, is there any way to only allow access
>to records in a table that have a field matching a certain value?
MySQL's access system can restrict ac
I am trying to make a database system in MYSQL, but I need to restrict
access to certain records in a table, is there any way to only allow access
to records in a table that have a field matching a certain value?
Mike
-
Before
Rick Emery writes:
> 2. To hide username and password, use PHP include files.Place this file
> in a directory which is NOT where you store your web-pages and scripts.
That's an excellent idea. Why haven't I done that? Shame on me
for not thinking of that solution. Thanks for the tip. :-)
---Original Message-
From: Anne [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 01, 2001 1:17 PM
To: [EMAIL PROTECTED]
Subject: DB permissions Question
I"m sorry, this is a very basic question -- but I am new to using SQL via
the web. I am on my own server, able to create databases/
I"m sorry, this is a very basic question -- but I am new to using SQL via
the web. I am on my own server, able to create databases/tables and
manipulate them to my heart's content at the command line connecting as
root. I cannot connect to the DBs any other way, however (e.g. logging in
at regul
of data that are relevant to their company.
Ken
- Original Message -
From: "o o" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 2:47 PM
Subject: Design/Permissions Question
> I'm relatively new to MySQL and am drawing up some
I'm relatively new to MySQL and am drawing up some ideas for writing a
support/trouble tracking database for my company. I envisioned a single
database with seperate tables for various data I would be storing
(IP/Connection info table, Machine Inventory Table, etc). Each table would
have data for
Hello:
I have read and re-read the available documentation and a variety of
tutorials regarding the MySQL Access Privelege System, but am still unclear
on a few details. MySQL is successfully installed, I am able to connect,
create databases,
tables, etc., and have so far been successful in obtai
15 matches
Mail list logo
