Client Login Area
Main Menu
Results 1 to 12 of 12

Thread: The EXECUTE permission error

  1. #1
    Verified Community Member
    Join Date
    December 12, 2008
    Posts
    7

    Default The EXECUTE permission error



    hi all;</p>

    Today i have got an error when i try to access sqlserver tables.following error i have got :</p>

    <span><h2> The EXECUTE permission was denied on the object 'ShowHierarchyForum', database 'celtictiger', schema 'dbo'. </h2></span>

    <font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

    Description: An
    unhandled exception occurred during the execution of the current web
    request. Please review the stack trace for more information about the
    error and where it originated in the code.



    Exception Details: System.Data.SqlClient.SqlException:
    The EXECUTE permission was denied on the object 'ShowHierarchyForum',
    database 'celtictiger', schema 'dbo'.



    Source Error:



    <table bgcolor="#ffffcc" width="100%">
    <tbody><tr>
    <td>
    <code></code><pre>Line 69: sqlCommand.Connection=mycon;
    Line 70:
    <font color="red">Line 71: SqlDataReader myr = sqlCommand.ExecuteReader(CommandBehavior.CloseConn ection);
    </font>Line 72: return myr;
    Line 73: </pre>

    </td>
    </tr>
    </tbody></table>




    Source File: c:\domains\celtictigerproperties.com\wwwroot\forum \App_Code\classes\clsDataAccess.cs Line: 71
    </font></p>

    </p>

    </p>

    How can i fix this error. Please help me as soon as possible.</p>

    Thanks</p>

    Snehasish</p>

  2. #2
    ASPnix Administration Roma's Avatar
    Join Date
    June 27, 2005
    Location
    Denver, CO
    Posts
    4,066

    Default Re: The EXECUTE permission error



    I have added full trust permissions to your domain. Hope this works.
    Roma
    Friendly ASPnix Administrator


    https://www.aspnix.com
    roma@aspnix.com



    ASPnix on Facebook

  3. #3
    Verified Community Member
    Join Date
    December 12, 2008
    Posts
    7

    Default Re: The EXECUTE permission error



    hi;


    After you added full trust i can not access any page of the site.When i am trying to access site i getting this error:
    Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

    Parser Error Message: Sections must only appear once per config file. See the help topic &lt;location&gt; for exceptions.

    Source Error:








    [No relevant source lines]



    Source File: web.config Line: 15


    Please help me.

  4. #4
    ASPnix Administration Roma's Avatar
    Join Date
    June 27, 2005
    Location
    Denver, CO
    Posts
    4,066

    Default Re: The EXECUTE permission error



    Full trust didn't change anything to your site, it's just a permission setting. Please check your code. </p>
    Roma
    Friendly ASPnix Administrator


    https://www.aspnix.com
    roma@aspnix.com



    ASPnix on Facebook

  5. #5
    Verified Community Member
    Join Date
    December 12, 2008
    Posts
    7

    Default Re: The EXECUTE permission error



    hi;

    Thanks for reply;This is my webconfig page.What is the wrong.I have accessed website by this config file previously.


    [b]&lt;?xml version="1.0"?&gt;
    &lt;!--
    Note: As an alternative to hand editing this file you can use the
    web admin tool to configure settings for your application. Use
    the Website-&gt;Asp.Net Configuration option in Visual Studio.
    A full list of settings and comments can be found in
    machine.config.comments usually located in
    WindowsMicrosoft.NetFrameworkv2.xConfig
    --&gt;
    &lt;configuration&gt;
    &lt;system.diagnostics&gt;
    &lt;sources&gt;
    &lt;source name="System.Net"&gt;
    &lt;listeners&gt;
    &lt;add name="System.Net"/&gt;
    &lt;/listeners&gt;
    &lt;/source&gt;
    &lt;source name="System.Net.Sockets"&gt;
    &lt;listeners&gt;
    &lt;add name="System.Net"/&gt;
    &lt;/listeners&gt;
    &lt;/source&gt;
    &lt;/sources&gt;
    &lt;switches&gt;
    &lt;add name="System.Net" value="Verbose" /&gt;
    &lt;add name="System.Net.Sockets" value="Verbose" /&gt;
    &lt;/switches&gt;
    &lt;sharedListeners&gt;
    &lt;add name="System.Net"
    type="System.Diagnostics.TextWriterTraceListener"
    initializeData="system.net.log"
    /&gt;
    &lt;/sharedListeners&gt;
    &lt;trace autoflush="true" /&gt;
    &lt;/system.diagnostics&gt;
    &lt;appSettings&gt;
    &lt;!-- PayPay parameters--&gt;
    &lt;add key="googlemaps.subgurim.net" value="ABQIAAAA9I-_Ujv67zIItdiN1aJhOBRwd5OUsAjaitMyjCdHrTBtcL44SxRUk VrVy82beaLzYZVi-ye96GRYGg" /&gt;
    &lt;add key="BusinessEmail" value="celtictigerproperties@gmail.com"/&gt;
    &lt;add key="CancelPurchaseUrl" value="http://www.celtictigerproperties.com/default.aspx"/&gt;
    &lt;add key="ReturnUrl" value="http://www.celtictigerproperties.com/Payment.aspx"/&gt;
    &lt;add key="NotifyUrl" value="http://www.celtictigerproperties.com/IPNHand.aspx"/&gt;
    &lt;add key="CurrencyCode" value="USD"/&gt;
    &lt;add key="UseSandbox" value="false"/&gt;
    &lt;add key="SendToReturnURL" value="true"/&gt;
    &lt;add key="GoogleAPIKey" value="ABQIAAAA9I-_Ujv67zIItdiN1aJhOBRwd5OUsAjaitMyjCdHrTBtcL44SxRUk VrVy82beaLzYZVi-ye96GRYGg"/&gt;
    &lt;/appSettings&gt;
    &lt;connectionStrings&gt;
    &lt;add name="connStr" connectionString="Server=8.8.246.34;Database=celti ctiger;User ID=xxxx;Password=xxxx;Trusted_Connection=False" /&gt;
    &lt;/connectionStrings&gt;
    &lt;system.web&gt;
    &lt;customErrors mode="Off"/&gt;
    &lt;!--
    Set compilation debug="true" to insert debugging
    &

  6. #6
    Verified Community Member
    Join Date
    December 12, 2008
    Posts
    7

    Default Re: The EXECUTE permission error

    Hi;
    I think my config filehave no problem.I could access site before.I did not changed anything in config file.
    Hope you will reply meas early as possible.
    Thank you.

  7. #7
    ASPnix Administration Chris's Avatar
    Join Date
    October 11, 2008
    Location
    Denver, Colorado
    Posts
    802

    Default Re: The EXECUTE permission error

    Doesnt look like a .NET permissions issue looks like the user doesnt have access to the stored procedure you are running. Run this command
    GRANT EXECUTE ON [ShowHierarchyForum] TO [theUserYouAreRunningUnder]

    See if this fixes it.
    Christopher York
    ASPnix Administration Team
    www.aspnix.com

  8. #8
    ASPnix Administration Roma's Avatar
    Join Date
    June 27, 2005
    Location
    Denver, CO
    Posts
    4,066

    Default Re: The EXECUTE permission error



    I've seen removing and adding SQL user in HELM fixes DBO permissions.</p>
    Roma
    Friendly ASPnix Administrator


    https://www.aspnix.com
    roma@aspnix.com



    ASPnix on Facebook

  9. #9
    Verified Community Member
    Join Date
    December 12, 2008
    Posts
    7

    Default Re: The EXECUTE permission error



    hi;

    today i have checked for existing sql user in HELM.I have seen that existing sql user have no permission as db_owner.it have only permission as public.When i have tried to set its permission as db_owner i got an error "User does not have permission to perform this action".How can i fix this?

    I created all of database tables from existing my sql user.So according to your advice if i delete my existing sql user and create new one will new sql user be able to access all tables?

  10. #10
    ASPnix Administration Chris's Avatar
    Join Date
    October 11, 2008
    Location
    Denver, Colorado
    Posts
    802

    Default Re: The EXECUTE permission error

    <P mce_keep="true">Did you try what Roma said to do? Remove the user, then add it back?'</P>
    <P mce_keep="true"></P>
    <P mce_keep="true">Not too sure on your question about will it remove from the tables. With mySQL the user is based on database access, and any user that has access to that database has access to its underlying tables aswell.</P>
    Christopher York
    ASPnix Administration Team
    www.aspnix.com

  11. #11
    ASPnix Administration Roma's Avatar
    Join Date
    June 27, 2005
    Location
    Denver, CO
    Posts
    4,066

    Default Re: The EXECUTE permission error



    [quote user="snehasish"]

    So according to your advice if i delete my existing sql user and create new one will new sql user be able to access all tables?


    [/quote]

    Yes, you should be able to do that.
    Roma
    Friendly ASPnix Administrator


    https://www.aspnix.com
    roma@aspnix.com



    ASPnix on Facebook

  12. #12
    Unverified User
    Join Date
    March 26, 2009
    Posts
    1

    Default Re: The EXECUTE permission error



    I am getting snagged on something that appears related to this.I cannot execute this SQL on the SQL 2008 Server
    </p>

    GRANT EXECUTE ON [dbo].[*sp name*] TO [*User Name*] AS [dbo]

    It appears when an account is created in HELM it does not have full permissions. Here's what I did </p>

    In HELM I created my user:
    I built a database and created a SP as that User.
    I went to give execute permissions on the SP but AS DBO. I get this response:
    "Cannot grant, deny, or revoke permissions to sa, dbo, entity owner, information_schema, sys, or yourself."

    I did the same thing on another SQL Server with the same database and the same SP and the same configuration, securables, schemas, owned schemas. Can it be that when creating a user in HELM that user does not have sa rights? How does one create an "Administrator" with full privileges if not through HELM?
    </p>

    Yes, I did try deleting and recreating my user. This did not change anything. I tried creating another user and used that user to try to grant privileges to the first one. That didn't fly either.</p>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •