User Profile Setup - Oracle to MySQL comparison 1

[balderdash]

Hi,

I am a newbie to both MySQL and Oracle. I understand that within Oracle you are able to create 'roles' and assign access/functions to that 'role'. This then allows you to assign a username to a role thus giving the required access to a database instantly.

I have been looking in MySQL for this functionality and con not see anything like it. Is anyone able to point me in the right direction or does this not exist?

The reason I ask is that I am trying to write a VB.Net application that references a users role when starting up and thus controlling the options a user has (i.e. order entry, stock control, finance and payments etc).

Any help would be greatly apprecaited.

Simon

 

[azzazzello]

In regards to setting up permissions, I believe the information you are looking for is here.

http://dev.mysql.com/doc/mysql/en/privilege-system.html

As for roles in how you describe them, I do not believe you can do that in mysql. What you can do is save permission-granting commands in a file and just run appropriate one for a user when need be

 

[balderdash]

azzazzello,

Thank you for your reply. I'll give that a read.

Simon

 

[TonyGroves]

MySQL doesn't have that level of sophistication.

However, you should be able to add an extra field to each record in the MySQL users table indicating the user's role, which your applications could read.

Alternatively, MySQL allows you to restrict access to individual databases, tables, and columns, to certain users, as pointed out by Azzazzello.

 

[balderdash]

Tony,

Thanks for this. I'll give that one a shot and see where I get to.

Simon

 

[Bastien]

Hey Tony,

That is a cool idea, what a neat concept to adding roles to the system.

Star for that.

Bastien

I wish my computer would do what I want it to do,
instead of what I tell it to do...