Login or Register to Ask a Question and Join Our Community


MySQL DevZone RSS

How can we get the role information in MYSQL?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Web Development MySQL DevZone RSS How can we get the role information in MYSQL?
# 1  
Old 07-24-2009
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  
Old 07-24-2009
Currently MySQL does not support roles (sets of privileges).
# 3  
Old 07-24-2009
But this tells that we can use the role in My SQL.

MySQL :: MySQL Workbench :: 7.4.3.1 Adding Roles
# 4  
Old 07-24-2009
No,
this reference is telling you that you can add roles in MySQL Workbench ...
# 5  
Old 07-24-2009
ok Thanks for your prompt reply.
# 6  
Old 08-05-2009
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
# 7  
Old 08-05-2009
I depends on how exactly you need to access the database. Many programming languages have included support for connecting to MySQL server.
Check the download page, the section is Drivers and Connectors.

If you want to use these client programs, I believe you need to install the whole bundle.
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. Cybersecurity

Role based access and security

Hello, We are planning to setup a Role based access and security to our Linux servers. We can use mostly use sudo for providing the limited access to service and files. My query is that how can we manage that members can edit/access only specific files (it would be 1 or multiple files or... (3 Replies)
Discussion started by: sunnysthakur
3 Replies

2. Solaris

Ssh to role

Hi all I need to run a command that only a role user and root can run, I need to run that command remotely by script but the roles ask for a password. Ex. from serverA with userA to serverB with userB: userA can ssh serverB using userB without askink for a password. ssh userB@serverB... (3 Replies)
Discussion started by: juanramos100
3 Replies

3. Solaris

Role not executing command

Hello Guys, I am studying RBAC. So I create a role called sysadm and gave it the "shutdown" profile. Now when I switch to that role, and execute the shutdown command $ shutdown -y -g0 -i5 The system responds with : shutdown: not found Can anyone help me with this please?... (1 Reply)
Discussion started by: cjashu
1 Replies

4. Shell Programming and Scripting

Need Role Name for my type of work

Hi , I am planning for the interview . I am having one question here , I worked on unix and shellscripting for 2 years Done- Ø Coding and testing of Server Monitoring ShellScripts Ø Deployment on UNIX production environment I have written so many shellscripts for monitoring... (5 Replies)
Discussion started by: aish11
5 Replies

5. Linux

What's role of swap in initrd?

Hello, I want to know why initrd need swap for work. In the shell of mkinitrd, it look for the swap partation for "swsuspdev", then write a sentence "resume /dev/sdXX" in the file init from initrd.gz, and the /dev/sdXX is the swap partation. Why initrd need swap when it boot a system? what is... (4 Replies)
Discussion started by: ZR_Lang
4 Replies

6. AIX

role based user

Hi .. I need to assign role based permission to users... How to assign role based permission in aix... Thanks.. (4 Replies)
Discussion started by: sumathi.k
4 Replies

7. What is on Your Mind?

UNIX starter role?

This may not be the right forum to put up a question like the one I'm about to ask. I am hoping that I would get very fruitful responses. i) I have been learning UNIX for sometime now, but my question is realistically what do I need to be able to be able to apply for UNIX jobs. What sort of... (6 Replies)
Discussion started by: B_Jay
6 Replies

8. What is on Your Mind?

Role of AI in any OS

In any given operating system, generally how much of AI software is involved? Is it related to user-friendliness of OS? What is the future of strong AI? (3 Replies)
Discussion started by: MULTIVERSE
3 Replies
Login or Register to Ask a Question