Re: user permissions to all DB

2007-08-21 Thread Jay Pipes
solidzh wrote: 2007/8/21, Jay Pipes <[EMAIL PROTECTED]>: Terry wrote: Hello, I want to grant a user all permissions to all DBs on the system as well as any new DBs that show up. I want to avoid having to modify permissions everytime a new DB is added. Is there a way to do this? GRANT SELECT

Re: user permissions to all DB

2007-08-20 Thread solidzh
2007/8/21, Jay Pipes <[EMAIL PROTECTED]>: > Terry wrote: > > Hello, > > > > I want to grant a user all permissions to all DBs on the system as > > well as any new DBs that show up. I want to avoid having to modify > > permissions everytime a new DB is added. Is there a way to do this? > > GRANT S

Re: user permissions to all DB

2007-08-20 Thread Rolando Edwards \(DBA\)
Grant the necessary privileges to each database individually and leave out > 'mysql'. > > Unfortunately, you cannot grant privileges to all databases and revoke > privileges from one schema ('mysql' in this instance) > You must enumerate the databases you specifica

Re: user permissions to all DB

2007-08-20 Thread Jay Pipes
a ('mysql' in this instance) You must enumerate the databases you specifically want to grant the user privileges to. GUARD THE mysql SCHEMA WITH YOUR LIFE, PLEASE - Original Message - From: "Jay Pipes" <[EMAIL PROTECTED]> To: "Terry" <[EMAIL PROT

Re: user permissions to all DB

2007-08-20 Thread Rolando Edwards
ave out 'mysql'. Unfortunately, you cannot grant privileges to all databases and revoke privileges from one schema ('mysql' in this instance) You must enumerate the databases you specifically want to grant the user privileges to. GUARD THE mysql SCHEMA WITH YOUR LIFE, PLEASE

Re: user permissions to all DB

2007-08-20 Thread Jay Pipes
Yep. Terry wrote: Just to verify, will that include all new databases? On 8/20/07, Jay Pipes <[EMAIL PROTECTED]> wrote: Terry wrote: Hello, I want to grant a user all permissions to all DBs on the system as well as any new DBs that show up. I want to avoid having to modify permissions every

Re: user permissions to all DB

2007-08-20 Thread Terry
Just to verify, will that include all new databases? On 8/20/07, Jay Pipes <[EMAIL PROTECTED]> wrote: > Terry wrote: > > Hello, > > > > I want to grant a user all permissions to all DBs on the system as > > well as any new DBs that show up. I want to avoid having to modify > > permissions everyti

Re: user permissions to all DB

2007-08-20 Thread Jay Pipes
Terry wrote: Hello, I want to grant a user all permissions to all DBs on the system as well as any new DBs that show up. I want to avoid having to modify permissions everytime a new DB is added. Is there a way to do this? GRANT SELECT, INSERT, CREATE, ... ON *.* TO 'username'@'hostname' IDE