Hi!
On Sep 21, 2009, at 12:02 PM, Ronald Bradford wrote:
For example, Jay's syntax included IDENTIFIED BY. By definition, is
CREATE USER needed now? is IDENTIFIED needed now? User
authentication is managed externally.
I would see no reason not to have a GRANT and REVOKE syntax. It
would be good for somebody to determine what part of the current
MySQL syntax is not ANSI SQL.
For user creation we need an API that would connect to it and deliver
the parsed information to a subsystem.
Same for GRANT/REVOKE.
Cheers,
-Brian
I was more interested in knowing how the Drizzle team were planning
on implementing something as I had no information on it.
Jay's questions are a good point, when and how is it executed is the
first path. How it's implemented is the next step. What syntax is
used, GRANT/REVOKE is really the only SQL syntax option. What
external system is used behind the API, and then for example what
other means there are to create permissions in addition to SQL
syntax would also be interesting.
Regards
Ronald
On Mon, Sep 21, 2009 at 11:56 AM, Roy Lyseng <[email protected]>
wrote:
Hi Ronald,
is there any alternative to the SQL standard privilege system?
Regards,
Roy
Ronald Bradford wrote:
Hi All,
I have been working initially on the Authentication models that are
currently being offered for Drizzle, PAM, LDAP(via PAM), Http Auth.
Thanks to Eric for helping me fix one of three identified bugs there.
What I am unclear of is the policy or thought for user permissions
within Drizzle after user authentication. I'd consider this an
important packaging requirement but I am unclear if anything is
defined for Bell. I will give you a clear example.
How do you plan to restrict users to not creating or altering
objects for example?
How do you plan to restrict users to read only verses read write?
Regards
Ronald
------------------------------------------------------------------------
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
