copy user privileges to a newly created user.

[usaims]

Hello:

I have just created a user with specific permissions to certain tables
in different databases. Now I have to create serveral more users with
the same permission. Is there a command in MySQL that allows me to
create the new user by copying the privileges from a template user?

MySQL 4.0.16

usaims

[Thomas Bartkus]

"usaims" <us****@yahoo.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

Hello:

I have just created a user with specific permissions to certain tables
in different databases. Now I have to create serveral more users with
the same permission. Is there a command in MySQL that allows me to
create the new user by copying the privileges from a template user?

I believe you will want to script it using your favorite language - be it a
DOS batch file, VB script, VBA, BASH, Python, Perl. You want to pass 1 or
more GRANT statements to MySQL using a usr name and host as the input.

Here is a minimalist Linux/BASH example. Sorry - I don't remember enough DOS
batch file language except to say it would look exceedingly similar

------------------------------------------------------------------------
#! /bin/bash

# Did we specify the user name@host on the command line?
if [ $# -ne 1 ]
then echo 'Aborted! - Need to specify "usr@host" on the command line'
exit
fi

# The $1 parameter holds our usr@host variable
mysql -uYourUsr -pYourPwd <<USER_PERMIT
GRANT SELECT ON SomeDB.SomeTable TO "$1"
GRANT SELECT ON SomeOtherDB.SomeOtherTable TO "$1"
USER_PERMIT

[Thomas Bartkus]

"usaims" <us****@yahoo.com> wrote in message
news:11**********************@g47g2000cwa.googlegr oups.com...

Hello:

I have just created a user with specific permissions to certain tables
in different databases. Now I have to create serveral more users with
the same permission. Is there a command in MySQL that allows me to
create the new user by copying the privileges from a template user?

I believe you will want to script it using your favorite language - be it a
DOS batch file, VB script, VBA, BASH, Python, Perl. You want to pass 1 or
more GRANT statements to MySQL using a usr name and host as the input.

Here is a minimalist Linux/BASH example. Sorry - I don't remember enough DOS
batch file language except to say it would look exceedingly similar

------------------------------------------------------------------------
#! /bin/bash

# Did we specify the user name@host on the command line?
if [ $# -ne 1 ]
then echo 'Aborted! - Need to specify "usr@host" on the command line'
exit
fi

# The $1 parameter holds our usr@host variable
mysql -uYourUsr -pYourPwd <<USER_PERMIT
GRANT SELECT ON SomeDB.SomeTable TO "$1"
GRANT SELECT ON SomeOtherDB.SomeOtherTable TO "$1"
USER_PERMIT