Re: grant user privileges

2008-04-16 Thread Daniel Brown
On Tue, Apr 15, 2008 at 9:03 AM, Hiep Nguyen [EMAIL PROTECTED] wrote: hi all, i have an existing database (internal) with a user named 'admin', everything works fine as far as privileges concern. i just created a new database (test) and want to grant admin's privileges on test as same as

Re: grant user privileges

2008-04-16 Thread Hiep Nguyen
On Wed, 16 Apr 2008, Daniel Brown wrote: On Tue, Apr 15, 2008 at 9:03 AM, Hiep Nguyen [EMAIL PROTECTED] wrote: hi all, i have an existing database (internal) with a user named 'admin', everything works fine as far as privileges concern. i just created a new database (test) and want to grant

Re: grant user privileges

2008-04-16 Thread Daniel Brown
On Wed, Apr 16, 2008 at 1:18 PM, Hiep Nguyen [EMAIL PROTECTED] wrote: is there any command that can set so that admin's privileges on internal = admin's privileges on test??? what i'm trying to avoid is manually adjust admin's privileges on test if admin's privileges on internal changed.

Re: grant user privileges

2008-04-16 Thread Sebastian Mendel
Sebastian Mendel schrieb: Hiep Nguyen schrieb: hi all, i have an existing database (internal) with a user named 'admin', everything works fine as far as privileges concern. i just created a new database (test) and want to grant admin's privileges on test as same as internal. how do i do

grant user privileges

2008-04-15 Thread Hiep Nguyen
hi all, i have an existing database (internal) with a user named 'admin', everything works fine as far as privileges concern. i just created a new database (test) and want to grant admin's privileges on test as same as internal. how do i do this??? i tried (as root): grant all on test.* to

Re: grant user privileges

2008-04-15 Thread Srini
Can you give the output of the command show grants for admin; Thank You, -srini Hiep Nguyen wrote: hi all, i have an existing database (internal) with a user named 'admin', everything works fine as far as privileges concern. i just created a new database (test) and want to grant admin's

Re: grant user privileges

2008-04-15 Thread Sebastian Mendel
Hiep Nguyen schrieb: hi all, i have an existing database (internal) with a user named 'admin', everything works fine as far as privileges concern. i just created a new database (test) and want to grant admin's privileges on test as same as internal. how do i do this??? i tried (as root):