Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > mysql > answers

How to get Role information in MYSQL?

Newbie
  
Join Date: Jun 2009
Posts: 18
#1: Jul 24 '09
How can we get the role information in MYSQL?

Like we get in ORACLE from USER_ROLE_PRIVS table.
Canabeez's Avatar
Member
  
Join Date: Jul 2009
Location: Israel
Posts: 85
#2: Jul 24 '09

re: How to get Role information in MYSQL?

Quote:

Originally Posted by amit2781 View Post

How can we get the role information in MYSQL?

Like we get in ORACLE from USER_ROLE_PRIVS table.

Maybe you should try this link.
Newbie
  
Join Date: Jun 2009
Posts: 18
#3: Jul 27 '09

re: How to get Role information in MYSQL?

How do we get the Grantor oe Owner of the object for Grantee in MYSQL?

I went through all information_schema where I didn't found the Grantor or Owner Column instead everywhere found the only Grantee in user_privileges, table_privileges?
Reply

« previous question | next question »

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 226,272 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved