I need to prepare some sql scripts which take parameters... how can I do?
For example, suppose I want to have a sql script to create a new user granting to him
some privileges and inserting its name in some application specific tables
--
MySQL General Mailing List
For list archives: http
not a SQL command to query current privileges.
On Wed, 24 Dec 2003 14:17:45 -0500
Michael Stassen <[EMAIL PROTECTED]> wrote:
>
> Plinio Conti wrote:
> > Yes, I think I will do it with an additional table on the db server,
> > for the moment (I have no time to impl
parsing etc ... like
> you stated below everytime they press a button.
> The route your taking will be slower,more resource intensive and more
> complicated.
>
>
>
>
> - Original Message -
> From: "Plinio Conti" <[EMAIL PROTECTED]>
> To: &l
gt;
> >On Tue, 23 Dec 2003 12:47:11 +0200
> >Egor Egorov <[EMAIL PROTECTED]> wrote:
> >
> >> Plinio Conti <[EMAIL PROTECTED]> wrote:
> >> >
> > > > The manual page at http://www.mysql.com/doc/en/SHOW_GRANTS.html
> >> > says
To be honest, the fact I can't get it with only one query but I have to do:
1) SELECT CURRENT_USER();
2) SHOW GRANTS FOR valueExtractedByPreviousQuery;
is a little thing compared with work remaing to get usefull information:
I have to parse the strings returned by query 2, handle the wildcards,
]> wrote:
> Plinio Conti <[EMAIL PROTECTED]> wrote:
> >
> > The manual page at http://www.mysql.com/doc/en/SHOW_GRANTS.html
> > says:
> >
> > "To list grants for the current session one may use CURRENT_USER() function"
> >
> > But if I run
m the client
> when viewing the file.
>
>
> ----- Original Message -
> From: "Plinio Conti" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, December 21, 2003 5:55 PM
> Subject: Quering user privileges
>
>
> >
> > Is th
OW GRANTS FOR [EMAIL PROTECTED];"
It works. Did you guess why?
On Mon, 22 Dec 2003 15:37:43 +0200
Egor Egorov <[EMAIL PROTECTED]> wrote:
> Plinio Conti <[EMAIL PROTECTED]> wrote:
> >
> > Is there a way to query the privileges of current user if he hasn't
that would be greatly appreciated!)
Since for the rest my application was standard SQL92... it's a pity
bye
Plinio
On Mon, 22 Dec 2003 15:37:43 +0200
Egor Egorov <[EMAIL PROTECTED]> wrote:
> Plinio Conti <[EMAIL PROTECTED]> wrote:
> >
> > Is there a way to
Is there a way to query the privileges of current user if he hasn't the rights to read
the mysql system tables (user, db, hosts, etc..)
I mean, I CAN'T give a standard user the chance of read "system tables"!
But my client app wants to know if the current user has (for example) the rights to
wr
10 matches
Mail list logo
