SELECT command denied... for table 'proc' - Stored Procedure call

[Chuck]

Obviously it's an access problem. I'm using ASP.NET and have
successfully run data bindings, straight SQL script, but am trying to
use stored procedures and I am getting this error.

I'm on a shared server with Hosting.com, and their tech support is
looking into this. Is there anything I can do to help them figure
this out?

I'm using the 6.2.2 .net driver for mysql, if that helps.

[Chuck Savage]

I ran show grants in phpadmin, these are the results

GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY PASSWORD
'77c55d8a5469704e'
GRANT ALL PRIVILEGES ON ``.* TO 'user'@'%'

[Gordon Burditt]

You have a database named `` ? I doubt that second line gives you access
to any sensibly-named database.

Normally, I'd expect it to say:

GRANT ALL PRIVILEGES ON *.* TO 'user'@'%'

[Chuck Savage]

Ok, that was a copy/paste/user error in pasting that line, It says,

GRANT ALL PRIVILEGES ON `user`.* TO 'user'@'%'

[Gordon Burditt]

>Ok, that was a copy/paste/user error in pasting that line, It says,
>
>GRANT ALL PRIVILEGES ON `user`.* TO 'user'@'%'

Now, what was the whole error message you got? Spell the entire
message correctly. If it said something like "denied to
'user'@'localhost', your problem is that 'localhost' is not matched
by '%' (but '127.0.0.1, 'Localhost', and 'lOcAlHoSt' are' is). It's
a very special case. 'localhost' means "use a local socket". In
that case you need to grant privileges to user@localhost also.

[Chuck Savage]

Thanks for looking at this Gordon,

[MySqlException (0x80004005): SELECT command denied to user
'user'@'26.12.116.108' for table 'proc']
WebDatabase.user.UserDB.CountUsers() in UserDB.cs:219
testUser.WriteUserList() in c:\Websites\157900dq4\testUser.aspx.cs:
48
testUser.Page_Load(Object sender, EventArgs e) in c:\Websites
\157900dq4\testUser.aspx.cs:23
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp,
Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object
sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+627

[Jerry Stuckle]

http://www.lmgtfy.com/?q=%22select+command+denied+to+user%22+%22table+proc%22&l=1

See the first hit.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstu...@attglobal.net
==================

[Chuck Savage]

Thank you Jerry, I passed the link onto the tech support team at
hosting.com, hopefully they can take it from there.

[Mau C]

Chuck Savage ha scritto:

> Thank you Jerry, I passed the link onto the tech support team at
> hosting.com, hopefully they can take it from there.

Have you got a Plesk server as hosting ? It seems it doesn't support (or
somebody disabled) store procedures... ...
I had the same inconvenience. Really I was able to create store
procedure but wasn't able to call it.

Regards,
M.

[nasa]

* The process attempts to perform a SELECT statement on the 'proc' table. The 'proc' table is a system table which retains the procedures of all users on that mysql instance. On shared hosting, allowing userA to see the procedures of userB, which would include information about table structure, etc., would be considered breach of security.
* A workaround has been documented on several mysql resources which indicates this can be fixed by adding "Use Procedure Bodies=false;" to the connection string, i.e.:
* "server=localhost; user id=dbuser; password=password; database=dbname; Use Procedure Bodies=false;"

Chuck wrote:

SELECT command denied... for table 'proc' - Stored Procedure call
26-Jan-10

Obviously it is an access problem. I am using ASP.NET and have

successfully run data bindings, straight SQL script, but am trying to
use stored procedures and I am getting this error.

I am on a shared server with Hosting.com, and their tech support is

looking into this. Is there anything I can do to help them figure
this out?

I am using the 6.2.2 .net driver for mysql, if that helps.

Previous Posts In This Thread:

On Tuesday, January 26, 2010 3:28 PM
Chuck wrote:

SELECT command denied... for table 'proc' - Stored Procedure call
Obviously it is an access problem. I am using ASP.NET and have

successfully run data bindings, straight SQL script, but am trying to
use stored procedures and I am getting this error.

I am on a shared server with Hosting.com, and their tech support is

looking into this. Is there anything I can do to help them figure
this out?

I am using the 6.2.2 .net driver for mysql, if that helps.

On Tuesday, January 26, 2010 3:50 PM
Chuck Savage wrote:

I ran show grants in phpadmin, these are the resultsGRANT USAGE ON *.
I ran show grants in phpadmin, these are the results

GRANT USAGE ON *.* TO 'user'@'%' IDENTIFIED BY PASSWORD
'77c55d8a5469704e'

GRANT ALL PRIVILEGES ON ``.* TO 'user'@'%'

On Tuesday, January 26, 2010 4:06 PM
gordo wrote:

You have a database named `` ?
You have a database named `` ? I doubt that second line gives you access
to any sensibly-named database.

Normally, I'd expect it to say:

GRANT ALL PRIVILEGES ON *.* TO 'user'@'%'

On Tuesday, January 26, 2010 5:20 PM
Chuck Savage wrote:

Ok, that was a copy/paste/user error in pasting that line, It says,GRANT ALL
Ok, that was a copy/paste/user error in pasting that line, It says,

GRANT ALL PRIVILEGES ON `user`.* TO 'user'@'%'

On Tuesday, January 26, 2010 7:16 PM
gordonb.8nxg wrote:

Now, what was the whole error message you got?
Now, what was the whole error message you got? Spell the entire
message correctly. If it said something like "denied to
'user'@'localhost', your problem is that 'localhost' is not matched

by '%' (but '127.0.0.1, 'Localhost', and 'lOcAlHoSt' are' is). it is

a very special case. 'localhost' means "use a local socket". In
that case you need to grant privileges to user@localhost also.

On Tuesday, January 26, 2010 10:08 PM
Chuck Savage wrote:

Thanks for looking at this Gordon,[MySqlException (0x80004005): SELECT command
Thanks for looking at this Gordon,

[MySqlException (0x80004005): SELECT command denied to user
'user'@'26.12.116.108' for table 'proc']
WebDatabase.user.UserDB.CountUsers() in UserDB.cs:219
testUser.WriteUserList() in c:\Websites\157900dq4\testUser.aspx.cs:
48
testUser.Page_Load(Object sender, EventArgs e) in c:\Websites
\157900dq4\testUser.aspx.cs:23
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp,
Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object
sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
+627

On Tuesday, January 26, 2010 10:27 PM
Jerry Stuckle wrote:

Chuck Savage wrote:http://www.lmgtfy.com/?
Chuck Savage wrote:

http://www.lmgtfy.com/?q=%22select+command+denied+to+user%22+%22table+proc%22&l=1

See the first hit.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstu...@attglobal.net
==================

On Wednesday, January 27, 2010 1:47 AM
Chuck Savage wrote:

Thank you Jerry, I passed the link onto the tech support team athosting.
Thank you Jerry, I passed the link onto the tech support team at
hosting.com, hopefully they can take it from there.

On Wednesday, January 27, 2010 11:46 AM
Mau C wrote:

Chuck Savage ha scritto:Have you got a Plesk server as hosting ?
Chuck Savage ha scritto:

Have you got a Plesk server as hosting ? It seems it does not support (or

somebody disabled) store procedures... ...
I had the same inconvenience. Really I was able to create store

procedure but was not able to call it.

Regards,
M.

Submitted via EggHeadCafe - Software Developer Portal of Choice
Join Lists with LINQ - SharePoint 2010
http://www.eggheadcafe.com/tutorials/aspnet/b0c1cd0d-fe82-444e-a16e-7d3fb7d38eca/join-lists-with-linq--sh.aspx