In MySQL 8, how do you distinguish between Roles and Users in table mysql.user?

Hi there, In MySQL 8, how can you figure out if an entry in the mysql.user table is a role or a user? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL Anywhere, MySQL, InterBase, NexusDB and F

In MySQL 8.0, how does one recognize roles?

Hi, In MySQL 8.0, if you use CREATE ROLE, it seems to create an entry in mysql.users But how does one distinguish between roles and users? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Database Workbench - developer tool for Oracle, MS SQL Server, PostgreSQL, SQL

RE: MySQL Roles and Groups

2012 10:11 Para: mysql@lists.mysql.com Asunto: MySQL Roles and Groups Hi list, I want to know if there is a feature for creating roles or groups in MySQL? I want to create a user role "Managers", where i want to add all the manager logins and then give specific permissions to

Re: create roles/groups in MYSQL

MySQL, InterBase, NexusDB and Firebird! On 1 Aug 2012 21:56, "Aastha" wrote: Hello, I have 10 different users and i have to give different accesses to different tables. Is it possible to create a groups with different set of access rights on different tables. I know there are ROLES

Re: create roles/groups in MYSQL

a groups with different set of access rights on > different tables. > > I know there are ROLES and PROFILES in Oracle. Is there something similar > in MySQL. > > Thanks, > Aastha Gupta >

RE: create roles/groups in MYSQL

Sorry, nothing like Roles or Profiles. Copy & Paste. > -Original Message- > From: Aastha [mailto:aast...@gmail.com] > Sent: Wednesday, August 01, 2012 1:56 PM > To: mysql@lists.mysql.com > Cc: Aastha > Subject: create roles/groups in MYSQL > > Hello, > &g

create roles/groups in MYSQL

Hello, I have 10 different users and i have to give different accesses to different tables. Is it possible to create a groups with different set of access rights on different tables. I know there are ROLES and PROFILES in Oracle. Is there something similar in MySQL. Thanks, Aastha Gupta

UPDATE: 2 MySQL DBA FULLTIME ROLES located in Westlake Village, CA and Miami Beach, FL

MySQL DBA We seek to hire a talented MySQL DBA to join our dynamic teams in California and Miami. Both roles are for onsite roles (no telecommuting). We are a well established multimedia/online dating organization focused primarily on the development of Internet media properties and is a

roles table design

HI, I'm developing a cms, I need some suggessions regarding database design. I'm creating role table in which role name will be unique, so my question is that should I create roleid(int, autoincreament, primary key )? Same question for users table. Note: I'll have user role mapping table. -- Shar

Does MySQL 5.2 include support for Roles Based Access Control?

I find some code about role management in mysql5.2 's source code " \mysql-5.2.0-falcon-alpha\storage\falcon " Does MySQL 5.2 include support for roles based access control now? Does it be supported by falcon engine?

Re: MySQL and ROLES

At 9:01 +0100 3/17/04, Bram Mariën wrote: Hey I'm fairly new to MYSQL (installed 4.0.18 yesterday, but have played with it in the past), and I must say, I'm really really impressed about the speed, and the easy of administrating the server and it's data! But, as I've looked through the documentati

Re: MySQL and ROLES

Bram Mariën wrote: Hey I'm fairly new to MYSQL (installed 4.0.18 yesterday, but have played with it in the past), and I must say, I'm really really impressed about the speed, and the easy of administrating the server and it's data! But, as I've looked through the documentation, I miss the presc

MySQL and ROLES

Hey I'm fairly new to MYSQL (installed 4.0.18 yesterday, but have played with it in the past), and I must say, I'm really really impressed about the speed, and the easy of administrating the server and it's data! But, as I've looked through the documentation, I miss the prescence of 'ROLE' in M

Re: Multiple Roles

* Caroline Jen > In case that a user has multiple roles; for example, > John Dole is both author and editor, > > 1. I should have two rows for John Dole? > >John Dole author >John Dole editor > >or. I should have only one row and use comma '

Re: Multiple Roles

On Jan 2, 2004, at 4:28 AM, Caroline Jen wrote: 1. I should have two rows for John Dole? John Dole author John Dole editor or. I should have only one row and use comma ',' to separate the roles? John Dole author, editor 2. How do I create the table for

Re: Multiple Roles

On Fri, 2 Jan 2004, Caroline Jen wrote: > In case that a user has multiple roles; for example, > John Dole is both author and editor, > > 1. I should have two rows for John Dole? > >John Dole author >John Dole editor > >or. I should have only o

Re: Multiple Roles

Hi, > > In case that a user has multiple roles; for example, > > John Dole is both author and editor, > > > > 1. I should have two rows for John Dole? > > > >John Dole author > >John Dole editor > > > >or. I should have onl

Re: Multiple Roles

"Caroline Jen" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > In case that a user has multiple roles; for example, > John Dole is both author and editor, > > 1. I should have two rows for John Dole? > >John Dole author >John Dole

Multiple Roles

In case that a user has multiple roles; for example, John Dole is both author and editor, 1. I should have two rows for John Dole? John Dole author John Dole editor or. I should have only one row and use comma ',' to separate the roles? John Dole author,

Oracle roles in MySQL?

Does MySQL offer anything to take the place of Oracle's roles? I'm especially interested in the ability, when adding a new table (or a new view, in the future) to the database, to be able to grant the desired access to everyone who ought to have access, without having to enumer

Re: equivalents to ROLES in SQL-Server in MySQL.

On Tue, Jan 22, 2002 at 12:13:10PM +0530, sreedhar wrote: > Dear all, > > Is there any equivalents to ROLES in SQL-Server in MySQL. Not really, no. Have you already seen the documentation for MySQL's privilege system in the manual? Jeremy -- Jeremy D. Zawodny, <[EMAIL PROT

equivalents to ROLES in SQL-Server in MySQL.

Dear all, Is there any equivalents to ROLES in SQL-Server in MySQL. regards, Sreedhar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Roles

Date |Tue, 28 Aug 2001 09:41:02 -0700 >From |John Meyer <[EMAIL PROTECTED]> Hello! JM> In Oracle, I remember working with roles that I could assign to a user. Is JM> there such a mechanism, or are there plans to implement such a mechanism, JM> in MySQL. If you mean leve

Re: Roles

At 09:57 AM 8/28/01 -0700, you wrote: > > In Oracle, I remember working with roles that I could assign to a user. >Is > > there such a mechanism, or are there plans to implement such a mechanism, > > in MySQL. > >This sounds a lot link granting a user certain privileg

Re: Roles

> In Oracle, I remember working with roles that I could assign to a user. Is > there such a mechanism, or are there plans to implement such a mechanism, > in MySQL. This sounds a lot link granting a user certain privileges. Here's the part of the documentation that talks abo

Roles

In Oracle, I remember working with roles that I could assign to a user. Is there such a mechanism, or are there plans to implement such a mechanism, in MySQL. - Before posting, please check: http://www.mysql.com