The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Special Forums > Web Programming, Web 2.0 and Mashups > MySQL DevZone RSS
How can we get the role information in MYSQL? How can we get the role information in MYSQL?
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read


MySQL DevZone RSS MySQL Developer Zone RSS

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Developing MySQL Database Applications With PHP Part 1: Using the MySQL Improved Exte iBot Solaris BigAdmin RSS 0 06-12-2009 07:00 PM
The role of the ESB in CEP solutions iBot Complex Event Processing RSS News 0 07-29-2008 12:32 PM
UNIX starter role? B_Jay What's on Your Mind? 6 02-10-2008 10:27 PM
Role of AI in any OS MULTIVERSE What's on Your Mind? 3 11-04-2005 10:26 PM

Reply
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish Bulgarian Greek Powered by Powered by Google
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 07-24-2009
amit_27 amit_27 is offline
Registered User
  
 

Join Date: Dec 2008
Posts: 49
How can we get the role information in MYSQL?
How can we get the role information in MYSQL?

Like we get in ORACLE from USER_ROLE_PRIVS table.
  #2 (permalink)  
Old 07-24-2009
radoulov's Avatar
radoulov radoulov is offline Forum Staff  
addict
  
 

Join Date: Jan 2007
Location: Варна, България / Milano, Italia
Posts: 2,926
Currently MySQL does not support roles (sets of privileges).
  #3 (permalink)  
Old 07-24-2009
amit_27 amit_27 is offline
Registered User
  
 

Join Date: Dec 2008
Posts: 49
But this tells that we can use the role in My SQL.

MySQL :: MySQL Workbench :: 7.4.3.1 Adding Roles
  #4 (permalink)  
Old 07-24-2009
radoulov's Avatar
radoulov radoulov is offline Forum Staff  
addict
  
 

Join Date: Jan 2007
Location: Варна, България / Milano, Italia
Posts: 2,926
No,
this reference is telling you that you can add roles in MySQL Workbench ...
  #5 (permalink)  
Old 07-24-2009
amit_27 amit_27 is offline
Registered User
  
 

Join Date: Dec 2008
Posts: 49
ok Thanks for your prompt reply.
  #6 (permalink)  
Old 08-05-2009
amit_27 amit_27 is offline
Registered User
  
 

Join Date: Dec 2008
Posts: 49
If I have installed mysql using "mysql-essential-5.1.34-win32.msi" on "Comp1" and I want to connect to Comp1-> Mysql server from Comp2.

Then Is there any client requirement on Comp2 (like Oracle we have client) or I need to install "mysql-essential-5.1.34-win32.msi" this on Comp2 also.

If Client is required, Where Should I get this client?

Also If I need to access mysql server installed on windows from Unix platform(linux, Solaris, HPUX) So what are the steps to do on all these Unix platform to get connection on windows mysqlserver.


Amit
Reply

Bookmarks

« Get Dropped table info : table_schema information from information_schema.tables | What's New in the MySQL Enterprise Fall 2009 Release? - Interview with Mark Matthews »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Hybrid Mode Hybrid Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 11:36 PM.

The UNIX and Linux Forums - Learn UNIX and UNIX Commands RSS Feeds - Contact Us - The UNIX and Linux Forums - Learn UNIX and UNIX Commands - Archive - Top

Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language Translations Powered by .
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0