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.c om> wrote in message
news:11******** **************@ g47g2000cwa.goo glegroups.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.SomeTabl e TO "$1"
GRANT SELECT ON SomeOtherDB.Som eOtherTable TO "$1"
USER_PERMIT

[Thomas Bartkus]

"usaims" <us****@yahoo.c om> wrote in message
news:11******** **************@ g47g2000cwa.goo glegroups.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.SomeTabl e TO "$1"
GRANT SELECT ON SomeOtherDB.Som eOtherTable TO "$1"
USER_PERMIT