[sequel-pro] Setting table permissions

[urban232]

hi,

I'm trying to set table-level permissions on a mysql db and reading
the Sequel Pro feature request page I see there's an item which says
"Add/Edit User Permissions" feature has been implemented.

Could someone please tell me where to find this?

Also, I've setup a new user and not specifically granted any
permissions.

When i do 'show grants for myuser@localhost' I get:
GRANT USAGE ON *.* TO 'myuser'@'localhost' IDENTIFIED BY PASSWORD
'7f500a3b2edf7950'

The mysql docs say 'usage' means no access... but I can still login as
this user and read the whole database - wtf?

Basically, I need to have 2 users, one with full access and one with
select priv to some tables, insert to some others and no access to the
rest.

Any help would be greatly appreciated.

P.S. I have root access.


cheers

--
You received this message because you are subscribed to the Google Groups "Sequel Pro" group.
To post to this group, send email to seque...@googlegroups.com.
To unsubscribe from this group, send email to sequel-pro+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/sequel-pro?hl=en.

[Jakob Egger]

Dear Kevin,

The user manager will be available in Sequel Pro Version 0.9.8

You can download the release candidate of 0.9.8 at http://www.sequelpro.com/blog/

You can find it in the menu Database > User Accounts... (or click the toolbar icon)

Please keep in mind that user privileges do not only depend on the user name, but also on the host you are connecting from. It could be that myuser@localhost has no privileges, but myuser@% has all privileges!

Best Regards,
Jakob Egger

[urban232]

Update -

I figured out why my 'restrictive' permissions were not working -
plesk automatically grants full access to the db for any user you
create within it and the grants i ran created a duplicate account...

anyway, all done using sql commands - but is there a way to set these
using the sequel pro gui?

[urban232]

Thanks Jakob!

Yes - that duplication of accounts was a gotcha for me.

On Apr 20, 7:46 am, Jakob Egger <jabako...@gmail.com> wrote:
> Dear Kevin,
>
> The user manager will be available in Sequel Pro Version 0.9.8
>

> You can download the release candidate of 0.9.8 athttp://www.sequelpro.com/blog/

> > For more options, visit this group athttp://groups.google.com/group/sequel-pro?hl=en.

>
> --
> You received this message because you are subscribed to the Google Groups "Sequel Pro" group.
> To post to this group, send email to seque...@googlegroups.com.
> To unsubscribe from this group, send email to sequel-pro+...@googlegroups.com.

> For more options, visit this group athttp://groups.google.com/group/sequel-pro?hl=en.