LP6 Admin, Table perms, SQL?

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

LP6 Admin, Table perms, SQL?

Jussi Hirvi
How come it says in my Lasso Admin that the user "AnyUser" has, for "All
tables", SQL privileges? I don't remember adding that, and it doesn't look
very good. How could I get rid of it?

See partial screenshot at
http://www.greenspot.fi/temp/tableperms.jpg

Thanks,
Jussi Hirvi

--
Jussi Hirvi * Green Spot
Topeliuksenkatu 15 C * 00250 Helsinki * Puh. & fax 09-493 981
Matkapuh. 040-771 2098 (vain tekstiviestit)
[hidden email] * http://www.greenspot.fi

--
Jussi Hirvi * Green Spot
Topeliuksenkatu 15 C * 00250 Helsinki * Finland
Tel. & fax +358-9-493 981
Mobile +358-40-771 2098 (only text messages)
[hidden email] * http://www.greenspot.fi/


--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: LP6 Admin, Table perms, SQL?

Roddie Grant
SQL privileges are set at the Host level. Go to Setup->Groups->Hosts, ensure
AnyUser is selected in the group popup, and set Execute SQL to "Deny".

Sometimes the Execute SQL popup is not visible - it should be below "Name,
Status, Host and Port". If it's not there, email again - this is what I was
sorting yesterday.

Regards

Roddie Grant



on 8/6/05 11:00, Jussi Hirvi at [hidden email] wrote:

> How come it says in my Lasso Admin that the user "AnyUser" has, for "All
> tables", SQL privileges? I don't remember adding that, and it doesn't look
> very good. How could I get rid of it?
>
> See partial screenshot at
> http://www.greenspot.fi/temp/tableperms.jpg
>
> Thanks,
> Jussi Hirvi
>
> --
> Jussi Hirvi * Green Spot
> Topeliuksenkatu 15 C * 00250 Helsinki * Puh. & fax 09-493 981
> Matkapuh. 040-771 2098 (vain tekstiviestit)
> [hidden email] * http://www.greenspot.fi
>
> --
> Jussi Hirvi * Green Spot
> Topeliuksenkatu 15 C * 00250 Helsinki * Finland
> Tel. & fax +358-9-493 981
> Mobile +358-40-771 2098 (only text messages)
> [hidden email] * http://www.greenspot.fi/
>


--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage
Reply | Threaded
Open this post in threaded view
|

Re: LP6 Admin, Table perms, SQL?

Jussi Hirvi
In reply to this post by Jussi Hirvi
Roddie Grant kirjoitteli (8.6.2005 14:57):
> SQL privileges are set at the Host level. Go to Setup->Groups->Hosts, ensure
> AnyUser is selected in the group popup, and set Execute SQL to "Deny".

Thanks, that made it easy! I think I searched every other page but Hosts.
:-)

> Sometimes the Execute SQL popup is not visible - it should be below "Name,
> Status, Host and Port". If it's not there, email again - this is what I was
> sorting yesterday.

Strange. It's visible here. L6.0.6 / OS X.

- Jussi Hirvi

--
Jussi Hirvi * Green Spot
Topeliuksenkatu 15 C * 00250 Helsinki * Finland
Tel. & fax +358-9-493 981
Mobile +358-40-771 2098 (only text messages)
[hidden email] * http://www.greenspot.fi/


--
------------------------------
Lasso Support: http://support.omnipilot.com/
Search the list archives: http://www.listsearch.com/lassotalk.lasso
Manage your list subscription:  
http://www.listsearch.com/lassotalk.lasso?manage