you need CREATE Privileges.
http://dev.mysql.com/doc/refman/5.0/en/grant.html#grant-privileges
On Wed, Feb 27, 2013 at 10:42 PM, Rajeev Prasad rp.ne...@yahoo.com wrote:
Hello,
currently on this version of MySQL a database has been built for me to
use. and following privileges are given: I
is that he/she needs CREATE to create tables and
ALTER to alter them.
-Original Message-
From: Reindl Harald [mailto:h.rei...@thelounge.net]
Sent: Wednesday, February 27, 2013 12:55 PM
To: mysql@lists.mysql.com
Subject: Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
says who?
you MAY need CREATE privileges
but it not uncommon have a defined scheme and not allow
the user to create or drop tables, the user below is
able to do anything for a common web-app
to anser the OP's question
% in mysql is the same as * for the bash
so yes, % means any host
Am
...@thelounge.net]
Sent: Wednesday, February 27, 2013 12:55 PM
To: mysql@lists.mysql.com
Subject: Re: mysql Ver 14.12 Distrib 5.0.27 user privileges question
says who?
you MAY need CREATE privileges
but it not uncommon have a defined scheme and not allow the user to create or
drop tables, the user
Hi all,
I am trying to create a user with only SELECT,INSERT,UPDATE,DELETE
privileges on a database. My question is when I type show grants for
the user I create, it says the user has full privileges over the
database and I only want them to have the ones listed above.
mysql grant
, Denise [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 05, 2007 4:08 PM
To: mysql@lists.mysql.com
Subject: Privileges question.
Hi all,
I am trying to create a user with only SELECT,INSERT,UPDATE,DELETE
privileges on a database. My question is when I type show grants for
the user I create, it says
Greetings,
I am sorry if I am asking a question that has already been answered
somewhere. If it was and you know where - please let me know.
I am trying to give access to a user, who should have access to a
specific database with over 200 tables and should not have access to one
or two of
Greetings,
I am sorry if I am asking a question that has already been answered
somewhere. If it was and you know where - please let me know.
I am trying to give access to a user, who should have access to a
specific database with over 200 tables and should not have access to
one or two of
I am afraid you have read the docs correctly. Privileges exist at 4
levels: Global, Database, Table, and Column. So, for someone to only see
part of a database, you have to GRANT permissions to the specific tables
that user gets rights to work with. No other way around it.
However, you may be
Is this a typical situation? If those 1 or 2 tables have higher security
requirements than the rest, so some users should have access to all the
tables except them, another option would be to move them to a separate db.
Then you could grant the average user access to the db with the rest of
Installing a new RHEL box, with 3.23.58. (it's what RH provides, and I
don't feel like using stuff from out of the RH tree.) I am a little
confused about the privileges. I have done a
GRANT ALL on *.* to root IDENTIFIED BY 'password';
which is great, but if I run mysql so
mysql -u [EMAIL
At 15:18 -0800 2/23/04, Jim Richardson wrote:
Installing a new RHEL box, with 3.23.58. (it's what RH provides, and I
don't feel like using stuff from out of the RH tree.) I am a little
confused about the privileges. I have done a GRANT ALL on *.* to
root IDENTIFIED BY 'password';
which is great,
On Mon, Feb 23, 2004 at 05:30:38PM -0600, Paul DuBois wrote:
At 15:18 -0800 2/23/04, Jim Richardson wrote:
Installing a new RHEL box, with 3.23.58. (it's what RH provides, and I
don't feel like using stuff from out of the RH tree.) I am a little
confused about the privileges. I have done a GRANT
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 26, 2003 1:26 AM
To: michael young; [EMAIL PROTECTED]
Subject: Re: user privileges question
At 18:02 -0400 6/25/03, michael young wrote:
Hi,
I am creating a small web based program
Hi,
I am creating a small web based program for users to access the
data in the datbases. New databases will be added in later. I want to
create a user to access these databases with certain rights, not all
rights. Will I have to grant this user right to each database as I add
them in or
At 18:02 -0400 6/25/03, michael young wrote:
Hi,
I am creating a small web based program for users to access
the data in the datbases. New databases will be added in later. I
want to create a user to access these databases with certain rights,
not all rights. Will I have to grant this
Hi Michael,
you raised an interesting question.
I created a new account (testroot) I gave him all privileges - except the
GRANT privilege.
GRANT ALL ON *.* TO 'testroot'@'%' IDENTIFIED BY 'xxx';
mysql show grants for testroot;
Hi Paul,
2003 6 26 09:55Paul DuBois :
At 9:19 +0900 6/26/03, Nils Valentin wrote:
Hi Michael,
you raised an interesting question.
I created a new account (testroot) I gave him all privileges - except the
GRANT privilege.
GRANT ALL ON *.* TO 'testroot'@'%' IDENTIFIED BY 'xxx';
PROTECTED]
Sent: Wednesday, July 17, 2002 10:23 PM
Subject: Re: MySQL Privileges Question
Did you try:
FLUSH PRIVILEGES;
Also, to see what user can do with his permissions you can try this:
SHOW GRANTS FOR username;
Mihail
Quoting Yat-Shing Tam [EMAIL PROTECTED]:
Hi fellows,
I have
from what it reported.
Regards,
Michael
- Original Message -
From: [EMAIL PROTECTED]
To: Yat-Shing Tam [EMAIL PROTECTED]
Cc: MySQL Mailing List [EMAIL PROTECTED]
Sent: Wednesday, July 17, 2002 10:23 PM
Subject: Re: MySQL Privileges Question
Did you try:
FLUSH PRIVILEGES;
Also, to see
Hi fellows,
I have a MySQL privileges question and hope someone can provide some
input on it.
I have setup a user who can access only one db, say 'DB1'.
About the privileges, I set the account privilege like this:
1) In user table, this account has Host='%' User='user_name
Did you try:
FLUSH PRIVILEGES;
Also, to see what user can do with his permissions you can try this:
SHOW GRANTS FOR username;
Mihail
Quoting Yat-Shing Tam [EMAIL PROTECTED]:
Hi fellows,
I have a MySQL privileges question and hope someone can provide some
input on it.
I have
Hi All,
I have some database named DB1 and one table in it named TBL1. In TBL1
there is 3 columns: name, address, id.
There is mysql user named dbuser.
Now, I want to give to 'dbuser' privileges to read ONLY 'name' and
'address' columns from table 'TBL1'.
So, I added record to mysql.user
Hi All,
cut
Now, I want to give to 'dbuser' privileges to read ONLY 'name' and
'address' columns from table 'TBL1'.
So, I added record to mysql.user table (with no global privileges) -
thans to thar 'dbuser' is able to connect to MySQL server, and it
works OK. Further I added records to
24 matches
Mail list logo