.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Set execute permissions for web site at web host

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :ASP.Net
Hi all,    I have just succeeded doing a Publish to server from my local sql db and run the sql script on my web host's sql server 2005 db. (I'm very proud! :-)   )   Now, I get the dreaded The EXECUTE permission was denied on the object 'MyStoredproc', database 'db12345', schema 'dbo'. error. I can't set the permissions from within Visual Studio, can I? What should I ask the web host to do? a) Should I ask them to globally set execute permission on ...? b) Should I ask them to set execute permissions to ... for only INSERT/DELETE/UPDATE stored procedures? c) Should I ask them nothing, and handle this myself? If so, then how? And, the question remains, should I set execute permissions globally or on a per stored proc basis? And what's the name of the user who needs the property set correctly? The reason why I ask these questionsis that I used to work with winfomrs at a university. There people should have different permissions depending on what group of users they belonged to. In this instace I have no idea!   Muchos gracias in advance, Pettrer, Sweden

View Complete Post

More Related Resource Links

Required permissions cannot be acquired when host asp.net 3.5 application in godaddy


I got the following error when click print report button.

Application : asp.net 3.5

Crystal report : 10.5

Host: godaddy

Please help me.


Required permissions cannot be acquired.

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.Security.Policy.PolicyException: Required permissions cannot be acquired.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

File not found error when trying to open site permissions on a blog site

We have created a simple team site and a block subsite.  When trying to edit the site permissions we see the following error.  Any ideas? When opening a blog site and clicking Site Actions - site permissions we received a new page with the following error: Error File Not Found Troubleshoot issue with Microsoft Sharepoint Foundation Correlation ID: 51b54786-f344-4474-b88e-3080c363693 Date and Time: 3/24/2010 3:03:38 PM

Need a WebPart to show permissions on site

HiI need a web part that will display the permissions for a site (web part is added to the site) so that users can see what level of permissions have been set before they add any content.This will be Doc Libraries, Lists, Blogs etc.Does anyone know of such a thing?ThanksRob

New Document Library in a subsite is inheriting permissions from wrong site

I have a site collection (using the out-of-the-box Business Intelligence site template) called "BI Home". A couple weeks ago I created a bunch of subsites (Finance, Regulatory, Marketing, etc.) all using the BI site template, and then created a Document Library called "Reports" in each one of those subsites. Those are all working as expected. Yesterday I needed to create a new subsite (again, a BI site just off the root site collection) called "Operations". I created the subsite, and then created the "Reports" document library underneath it.  When I went to modify the permissions of the new document library (located here: /Operations/Reports), it said it was inheriting permissions from it's parent: "BI Home".  Why would this be?  Shouldn't the parent be "Operations" ?? All my other sites' "Reports" folders are inheriting permission from their respective parent, but any new sites I create seem to have this issue. Thanks in advance for any insight someone may provide! [SharePoint 2010 RTM on Win2k8R2 using SQL 2008R2 RTM on Win2k8R2]

host-named site collection, 401 error (SP Foundation 2010)

I'm trying to create a host-named site collection. However, after its creation, I try to access it with the browser and I'm challenged to enter my username/password  (validating through Active Directory, I believe) and I get a blank page. Looking in the IIS log I see a 401 error with sub-status 1. I'm creating everything programmatically through the  API. I'm following this article:  http://technet.microsoft.com/en-us/library/cc288637.aspx# It's not clear in the article exactly what DNS does or should do with host-named site collections. I added a line to my hosts file:   altlocalhost And I can ping altlocalhost with no problem. When I deploy directly a simple site collection without host-named stuff I'm not challenged to enter user name/password and the site works fine (and I'm authenticated with AD).  

Programmatically(WSS Web Services) Inheriting Parent Site Permissions for Workspaces

I'm able to create meeting work spaces in Sharepoint 2007 using the WSS web services. This issue that I'm running into is that the default is not inheriting permissions from the parent site. I'm looking for a way to configure this option for the work space programmatically through the use of the WSS web services. I've tried changing this in the template that I'm using to create the workspace, but this does not seem to effect the end results.Regards,Timothy H

EXECUTE permission denied on sp at web host

Hi all, I have recently succeeded doing a Publish to server from my local sql db and run the sql script on my web host's sql server 2005 db. Now, I get the "The EXECUTE permission was denied on the object 'MyStoredproc', database 'db12345', schema 'dbo'." error. I have Visual Studio Professional 2010, and that's where I create and manage my tables (in Server Explorer). However, when I right-click a stored procedure, I don't get a Seurity option or the like, where I could possibly set permissions. I'm a bit usure of what SqlServer applications I have installed (as they are intertwingled with the Aps.Net stuff somewhat). When I look at Add/Remove software, this is what I find: Microsoft Sql Server 2008 (562 MB)Microsoft Sql Server 2008 Native ClientMicrosoft Sql Server 2008 R2 Data-Tier Application FrameworkMicrosoft Sql Server 2008 R2 Data-Tier Application ProjectMicrosoft Sql Server 2008 R2 Management ObjectsMicrosoft Sql Server 2008 R2 Transact-Sql Language ServiceMicrosoft Sql Server 2008 Setup Support FilesMicrosoft Sql Server Compact 3.5 SP2 ENUMicrosoft Sql Server Database Publishing Wizard 1.3Microsoft Sql Server Database Publishing Wizard 1.4Microsoft Sql Server System CLR TypesMicrosoft Sql Server CSS Writer Can I use any of these apps to set the security settings? Or would I possibly not be allowed to change any settin

Error For Execute User Define Function in remote host.

Hi there.I wanna to call a user defined function in stored proc.it's ok in local test but in the host it rises error: Cannot find either column "dbo" or the user-defined function or aggregate "dbo.MinCount", or the name is ambiguous.What should i do?

How to use Host headers for SharePoint site ?

Hi all I have a running site on port 80 I then have created aother new web application and a site collection (collaboration) using the port which was displayed by default while creating the web application, where now the Url is htt://servername :47854 Now if I want to provide a valid url to the above url what are the suggested steps, Should that be achieved with the Host headers or DNS entry. Please provide the steps   Thanks . satyam

Sharepoint 2010: Get error: You do not have permissions to have lists and pages within My Site.

I am using the administrator login for the sharepoint 2010 farm.  I'm able to access My Site.  However, when I click on My content, I'm getting You do not have permissions to have lists and pages within My Site.   Any ideas?   Thanks.

Setting sql permissions for web site visitors

Hi all, I have my SqlServer 2005 database at a web host. I recently figured out how to set permissions for the stored procedures (see this link if you face the same problem: http://forums.asp.net/t/1600637.aspx) . Now I wonder: What permissions should I give the web site's visitors? In a stored procedure's Properties window, I have three availabale users, the db owner (the db name), "guest" and "public". My bet is on public.  As far as permission types go, I hev the following available: Alter, Control, Execute, Take Ownership, and View Definition. My guess is that the one of interest is Execute, correct?   In other words, should I set all stored procedures to Execute for public (not that I seem to have the permission to do that myself - I get an error message when I try to alter them)? If so, could I ask the web host to set them globally for me? Or should I only set stored procedure using UPDATE/INSERT/DELETE to Execute?   Thanks a lot for any replies, Pettrer  

Meetings.asmx web service to inherit parent site permissions



I am using the Meetings.asmx web service to create a sub site.  Unfortunately this does not provide a mechanism to inherit parent site permissions, it just creates a sub site with unique permissions which is not what I want.   In order to inherit the parent permissions I am using the Permissions.asmx.  Can someone please provide some sample code on how to do this, I tried various mechanims through the Permissions.asmx but does not seem to be able to get it right.




Host-named site collections and content deployment jobs (SharePoint 2007 Internet facing Web Sites)



I have an editing web application with multiple site collections (only accessible internally on a dedicated port), and I've one public facing web application (on port 80). Now I want to create several host-named site collections in the public facing web application (to limit the number of web apps in the farm), and then use content deployment jobs to push the content from the site collections on the editing web app into these host-named site collections.

Does anyone have any experience with this?
Do you see any issues?


SQL Server 2005 permissions error. The EXECUTE permission was denied on the object "xp_instance_reg


I have a SQL Server host running SQL 2005 9.00.4294 x86 Standard Edition running on Windows build 2195 SP4.  My client workstation is running only SQL Server 2005 workstaion components.   When a user of the host who has db_owner access attempts to view the properties of a table by right-clicking the table and then clicking Properties, the following error mesage is displayed:  

"The EXECUTE permission was denied on the object "xp_instance_regread", database 'mssqlsystemresource', schema 'sys'

For security purposes, I do not want to grant execute on xp_instance_regread to these users. Does anyone know of a workaround that will allow members of db_owner to access table properties using the abovementioned method and does not require execute access to be granted?




Users dont have permissions to core.css on specific site


I have a sharepoint website where somehow the permissions on it got messed up.  Users with read access can get to the site, but when they get thier the site is messed up.  I can replicate the look by disabling core.css on the site.  I checked and the users do have core.css in the source, but If you try to load it you get access denied.

The masterpage is referencing the core.css file that is relative to the site, not the one in _layouts.

How do I fix this permissions issue, It seems liek the only way to access core.css is through sharepoint designer and in there I cant see a way to fix the permissions.

How to get the permissions of a user or group that has "Limited Access" to a site



For a user or group that has "Limited Access" to a site, I'd like to be able to find all of the libraries, documents, etc that that user or group has been given permissions to.  I believe that I could accomplish this by iterating over all of the lists of the site, and then over all of the list items of each list, and checking if, for that list or list item, inheritance is broken and that user or group has been granted access.  However, I am hoping there is a cleaner, quicker alternative in which I don't have to iterate over all of the site content.

If that's not possible, I may be able to accomplish mostly what I need if I could find all of the site content which has unique permissions (and then simply iterate over that content to see if the user or group has been given permissions).

Any advice is greatly appreciated.




How to test a sharepoint site with lower permissions?


I finally got my site ready to go.  When I test it everything works fine with my Site Admin privileges.  So how do I see how well it works for someone with a lower permission level, such as visitor.

My site is part of a larger farm in a large corporate entity.  Users are established by the folks at HQ.  I'm using Sharepoint 2007.

So is there a test mode?  Or is there a way to create a fake user login at the local level?  Or anything else I might consider?


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend