.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

Setting sql permissions for web site visitors

Posted By:      Posted Date: September 15, 2010    Points: 0   Category :ASP.Net
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  

View Complete Post

More Related Resource Links

Setting permissions of a specific SharePoint workflow


We have a very simple workflow whereby an document placed in a public library (INBOX) is moved it to a private library (VERIFY) and then deleted. The workflow works correctly when someone who has access to the VERIFY library drops a record into the INBOX library.  However it does not work when the user does not have access to the VERIFY library.

I was told that I need to "set the AD group associated with a specific SharePoint workflow" but cannot find any reference to this in SPD.



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

Setting Managed MetaData default values on site creation

I am working on a project where the requirement is to have specific document content types.  I have therefore create a site columns feature which creates all my columns, I have a Site Contentypes feature which creates all my content type and I have list templates based on my content types.  I also have created a couple of Site definition features which create specific list instance based on my list template As part of my content types I have created a few Managed Metadata fields which I wanted to set defaults for on the creation of my sites.  I have therefore created a feature which is right at the end of the WebFeatures section in my ONET.xml.  This features enumerates through all lists, looking for specific column names(managed metadata columns) and looks to set these to specific values.  The code to set the default value on the field is: TaxonomyField documentCategoryField = (TaxonomyField)library.Fields["Document Category"]; if (documentCategoryTerm != null) { documentCategoryField.DefaultValue = documentLibraryDefault.ToString(); documentCategoryField.Update();                                                     }                         &n

The site master page setting currently applied to this site is invalid. Please select a new master p

I have defined a new master page and set it as default for the main site.  Any time I create a new subsite it does not apply the new master page and defaults back to the default.master.  The Site Master Page Settings shows this error. The site master page setting currently applied to this site is invalid. Please select a new master page and apply it The system master page setting currently applied to this site is invalid. Please select a new master page and apply it. Now if I select "Inherit site master page from parent of this site" and "Inherit system master page" and click ok the site will use the new master page and everything is fine.  There is only one modification to the master page that was done so I know the master page isn't invalid.  Does anyone know the answer other than recreating the new master page.

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]

Taxonomy term store additions via site setting are not visible to user in RC1

Is see that its possible to define Taxonomy term store via SharePoint main central  admin page. But when I try to add term store entries via a new site in the same collection ....  site setting -> Site Administration -> Term store management any new entries are not visible. That is to say when a user starts to enter a tag the helper dialog does not show any values added via the site but all values add via the central admin do appear. this seems like a bug and the is in RC1 or am I doing something wrong

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

Set execute permissions for web site at web host

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

Setting up Visual Studio with a cloud based SharePoint site

I have a SharePoint site on the cloud where I access it through a URL like this one; https://exampleemeamicrosoftonlinecom-1.sharepoint.emea.microsoftonline.com I can also edit the site with SharePoint Designer by pointing to the same URL. I'm at the stage in the project where I want to do some specific things so I am going to use Visual Studio, but I don't know how to set up Visual Studio with a cloud based SharePoint site? When I go to add a SharePoint site I get the following error; A SharePoint server is not installed on this computer. A SharePoint server must be installed to work with SharePoint projects. I also tried to add the URL as a server in Visual Studio but I get the error; Server name "https://exampleemeamicrosoftonlinecom-1.sharepoint.emea.microsoftonline.com" could not be found. Make sure the server name is correct. I have SharePoint Designer working with the SharePoint site, why won't Visual Studio work?  

Cannot crawl complex URL's without setting a site-wide rule to 'crawl as http content'. Help!

I have pages within a site that use a query string to provide dynamic data to the user (http://<site>/pages/example.aspx?id=1). I can get the content source to index these dynamic pages only if I create a rule which sets the root site (http://<site>/*) to 'include complex urls' and 'crawl sharepoint content as http content'. This is NOT acceptable as changing the crawling protocol from SharePoint's to HTTP will prevent any metadata from being collected on the indexed items. The managed metadata feature is a critical component to our SharePoint applications. To dispel any wondering of whether or not this is simply a configuration error on my part refer to http://social.technet.microsoft.com/Forums/en-US/sharepointsearch/thread/4ff26b26-84ab-4f5f-a14a-48ab7ec121d5 . The issue mentioned is my exact problem but the solution is unusable as I mentioned before. Keep in mind this is for an external publishing site and my search scope is being trimmed using content classes to only include documents/pages (STS_List_850 and STS_ListItem_DocumentLibrary). Creating a new web site content source and adding it to my scope presents 2 problems: duplicate content in scope and no content class defining it that I know of. What options do I have?

Setting permissions to Items/Views in a list

I have a list containing 2 FY's data. I need to make one of the FY year's data as read-only. Can i create a view filtering only this data and make only this view as read-only or do i need to edit permissions of individual items of the filtered FY and set it as read-only. Is there any other way of doing this?

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.

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.




Recent Visitors in Sharepoint site


Hi All

How to find out recent visitors in wss 3.0 site?



Setting permissions on specific items


I'm following a Books Online tutorial for setting up permissions.  I'm on to the 3rd and final stage of the tutorial, the part where I set specific permissions for users to a folder or a report.  (Here's the web page: http://msdn.microsoft.com/en-us/library/aa337494.aspx)

I'm confused about these instructions from that page:

To create a role definition for navigating folders

  1. In SQL Server Management Studio, connect to a report server, and then expand the report server node.

  2. Open Security folder.

  3. Right-click Roles and select New Role. The New User Role dialog box appears.

  4. In Name, enter Folder Navigation.

  5. In Task, select View Folders.

  6. Click OK.

Assuming step 1 refers to the ReportServer database, should it be a database role or an application role?  And where do I find "Task"?  There must be several errors in this page.  Could somebody please clarify these instructio

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.

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