: 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
d
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 27.02.
.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
>
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 wrote:
> Hello,
>
> currently on this version of MySQL a database has been built for me to
> use. and following privileges are given: I am not able to c
, 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
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 SELECT,INSER
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 the
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
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 them.
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 them.
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 AL
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, b
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 PROTEC
> -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,
> >
Hi Paul,
2003年 6月 26日 木曜日 09:55、Paul 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'@'
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';
mysql> show grants for testroot;
+---
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;
+-
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 user
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
mmand and nothing unusal 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
gt;
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 what user can do with his permissions you can try this:
>
> SHOW GRANTS FOR us
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 som
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='%
> Hi All,
> 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
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 table
25 matches
Mail list logo