Re: Creacion de Usuarios
Puedes hacer lo siguiente,
mysql> revoke all privileges on *.* from 'usuario';
mysql> grant usage on *.* to 'usuario';
mysql> show privileges;
Las tres opciones anteriores hacen lo siguiente:
La primera, quita todos los permisos habidos y por haber en la DB principal al usuario en cuestion.
La segunda otorga el privilegio 'usage' al usuario que le quitaste los permisos de todo, 'usage' lo unico que hace es permitir que el usuario pueda ver las DB o tablas que hay en el esquema principal.
El tercero, bueno te mostrara detalladamente, todos los privilegios disponibles dentro de Mysql, con su descripcion detallada de que hace y para que sirve cada uno, me parece que te servira para asignar o revokar permisos a un usuario.
Subject
Views
Written By
Posted
54958
July 11, 2006 07:51AM
8937
July 21, 2006 09:35AM
7134
July 24, 2006 08:37AM
4229
February 25, 2010 05:22PM
6131
May 17, 2010 02:44AM
3522
August 30, 2010 08:14AM
3534
September 15, 2010 04:21PM
3906
November 09, 2010 06:58AM
6101
June 07, 2010 03:05PM
4337
August 31, 2011 05:59AM
6619
July 28, 2006 08:22AM
5798
March 15, 2008 10:59AM
5294
March 17, 2008 04:10AM
14648
April 22, 2008 01:27PM
8774
June 16, 2008 04:40PM
6653
July 28, 2006 05:43PM
7857
August 30, 2006 09:33AM
6135
July 09, 2007 10:47AM
5295
May 23, 2008 12:34AM
8857
May 17, 2008 07:03AM
6950
May 22, 2008 12:07PM
5804
July 25, 2008 12:46PM
8843
November 14, 2007 03:15AM
8842
November 14, 2007 12:26PM
6293
January 10, 2008 10:39AM
5720
March 04, 2008 11:50AM
7545
June 03, 2008 10:58AM
7208
January 17, 2009 09:27PM
5495
January 18, 2009 07:33AM
5584
January 21, 2009 07:53PM
6224
January 24, 2009 09:09PM
5299
January 22, 2009 12:12AM
5368
January 23, 2009 04:52PM
3694
March 18, 2010 07:16PM
6681
January 21, 2008 02:07PM
5812
January 21, 2008 04:04PM
9476
January 22, 2008 10:56AM
6673
January 22, 2008 02:47PM
6126
February 09, 2008 05:56AM
8126
June 13, 2011 08:59AM
7954
February 09, 2008 05:58AM
6353
February 11, 2008 05:28PM
5541
May 11, 2008 12:31PM
12140
February 12, 2008 06:04PM
7922
March 11, 2008 05:17AM
4654
April 10, 2010 06:07PM
8926
August 25, 2008 07:22PM
9226
March 23, 2008 09:27AM
5706
April 19, 2008 05:08PM
5265
May 11, 2008 12:28PM
7898
March 28, 2008 10:20AM
6863
June 05, 2008 08:21AM
5194
May 20, 2009 06:30PM
5621
April 04, 2008 08:20AM
7917
April 18, 2008 12:52PM
5177
May 20, 2009 06:27PM
5991
April 29, 2008 04:17AM
8316
May 12, 2009 02:56PM
5878
May 13, 2009 01:26AM
5761
April 30, 2008 02:21PM
5495
June 05, 2008 08:02AM
7577
May 02, 2008 01:15PM
5570
May 08, 2008 08:13PM
5508
May 05, 2008 06:25AM
5818
May 08, 2008 09:05AM
7086
May 08, 2008 03:17PM
Re: Creacion de Usuarios
7995
June 04, 2008 01:47PM
7051
May 19, 2008 03:50AM
5147
May 29, 2008 04:34AM
5254
May 29, 2008 05:54AM
5496
June 02, 2008 11:47AM
12162
June 04, 2008 02:01PM
5394
June 05, 2008 06:07AM
6378
June 05, 2008 07:46AM
6833
June 09, 2008 02:31AM
4952
June 09, 2008 09:53AM
5288
June 11, 2008 10:47AM
5966
June 16, 2008 06:28AM
5417
June 24, 2008 08:32PM
4447
March 26, 2009 11:07AM
4704
March 26, 2009 12:15PM
7987
September 03, 2008 04:34PM
10070
September 05, 2008 04:09AM
5628
December 14, 2008 11:49AM
8001
May 19, 2009 08:31AM
5218
May 19, 2009 08:43AM
5606
August 30, 2009 09:27PM
6112
May 26, 2009 05:30PM
4543
June 12, 2009 04:14PM
4413
July 29, 2009 08:59AM
4391
August 02, 2009 09:19PM
5134
August 02, 2009 03:18PM
4824
August 28, 2009 06:55PM
8111
August 31, 2009 03:02PM
5492
September 07, 2009 03:51AM
4041
February 24, 2010 03:37PM
5176
September 14, 2009 01:54PM
5278
September 24, 2009 09:43PM
4307
September 25, 2009 09:30AM
4671
October 07, 2009 01:51AM
6321
November 05, 2009 05:09PM
4653
November 25, 2009 06:51AM
7225
November 26, 2009 07:27AM
3736
November 26, 2009 04:13AM
4860
December 08, 2009 03:56PM
4173
December 28, 2009 10:31PM
4797
February 02, 2010 09:55AM
5218
February 11, 2010 12:06AM
11475
February 12, 2010 08:35AM
7477
February 12, 2010 09:20AM
4595
March 01, 2010 03:08PM
3876
March 03, 2010 08:23AM
5917
March 05, 2010 07:57AM
3427
March 06, 2010 04:37PM
4942
March 08, 2010 03:35PM
14146
March 29, 2010 10:12AM
4073
April 10, 2010 05:46PM
5387
April 13, 2010 03:43PM
3661
August 08, 2010 03:15PM
3476
August 08, 2010 03:54PM
2475
September 15, 2010 10:06AM
14168
September 18, 2010 10:24AM
3901
October 11, 2010 06:20PM
2743
October 10, 2010 10:05AM
2446
November 13, 2010 05:53AM
2767
October 18, 2010 04:05PM
2563
October 18, 2010 07:19PM
2274
October 18, 2010 07:34PM
2981
October 19, 2010 02:52PM
2941
October 25, 2010 09:30AM
2446
October 25, 2010 11:16AM
2255
January 14, 2011 05:37AM
2555
January 20, 2011 03:13PM
2640
January 23, 2011 09:41AM
3932
February 14, 2011 09:18AM
3492
January 31, 2011 04:19PM
3390
February 02, 2011 11:41AM
5220
March 03, 2011 02:57PM
2256
March 17, 2011 01:35PM
2750
July 30, 2011 10:51PM
1836
August 15, 2011 03:50PM
2898
September 20, 2011 10:54AM
1715
September 20, 2011 01:53PM
1756
October 14, 2011 08:21AM