Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 295
  • Last Modified:

mysql and java: check if user hat right to change database structure

hello all,

in a java project i would like to check a database user if he has right of change database structure. (such as drop_priv, alter_priv, delete_priv)

the first question is: how do i check the drop right of  'myuser' , who has localhost as host.
here some details:
in mysql, i have tried to use
select Delete_priv from mysql.user where User='myuser';
to find if use has delete right. but the result i got is "Yes" and "No". because in database there are two users with the same name, one has "localhost" as host, another has "%" as host.  

second question is: how do i get the result of sql above in java code?

thanks,
wantime
0
wantime
Asked:
wantime
  • 3
  • 2
3 Solutions
 
for_yanCommented:
do you mean that you are happy with your sql, you just want to know how to get it in the java code?


If so, then you need to use JDBC
http://download.oracle.com/javase/tutorial/jdbc/

If  your question is different, please, elaborate
0
 
CEHJCommented:
You probably want the following and you can get the result in java by using this in the usual way, as any other query
select user from mysql.user where user = 'myuser' and host = 'localhost' and drop_priv = 'Y';

Open in new window

0
 
wantimeAuthor Commented:
thanks. the first question is resolved.  i have used

select Delete_priv from mysql.user where User='myuser' and host ='localhost';

to found to priv for user.

yes, i need to get the result in java code. i will have a look at the links you given.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
CEHJCommented:
>>yes, i need to get the result in java code.

That's pretty straightforward. See http://dev.mysql.com/doc/refman/5.0/en/connector-j-usagenotes-basic.html
0
 
wantimeAuthor Commented:
thanks!  The problem in mysql is resolved. however, i also face the problem in mssql database. so i open a new thread about this issue. the link is here:

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_27317351.html
0
 
CEHJCommented:
>>
thanks. the first question is resolved.  i have used

select Delete_priv from mysql.user where User='myuser' and host ='localhost';
>>

(which was suggested by me, so i don't know why you accepted a different answer wantime..?)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now