.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

dbowner permission being removed overnight

Posted By:      Posted Date: October 07, 2010    Points: 0   Category :SharePoint


Here is the problem I have:

I have an event on a list that create a timer job. Because the users do not have permission to create timer jobs, the code impersonates a new user I have created (lets call him elevatedtimer). I have given elevatedtimer farm admin, but the event would not work until I also gave him dbowner on the Admin_Content DB through SQL. The situation is, once I give him this access, it works fine and can create timer jobs as expected, however the following morning the event fails on creating a timer job, and evevatedtimer's dbowner permission has been removed from the database. This has happened 2 or 3 days in a row. Once I set that permission again, it works fine.

What could possibly be doing this? Is there a SP timer job that goes through and cleans up DB permissions? this account is not being used for anything else except running this event code, its not a service account for anything else. Should he be getting access to the Admin_Content db anyway because he is a farm admin?

Thanks in advance

View Complete Post

More Related Resource Links

System.Security.SecurityException: Request for the permission of type 'System.Web.AspNetHostingPerm


Good Day all,

Having an issue with an outside user accessing my IIS7 box. I do not have this problem when running the website from my host machine. I found this post: Http://forums.asp.net/t/1371394.aspx. I assure you that this is not a solution because I am not storing any of my files on a network share. 

What do you think my approach should be. 

I already have read rights to IIS user to my BIN folder. 

Thanks for the help. 

Error "user does not have permission to perform this operation" with User Instance = True.


I setup SQL Server 2005 / SQL Express. All works fine in SQL Server 2005.

I am connecting to a SQL Database from VS 2005,  Tools/Connect to Database. I set the Data Source to "Microsoft SQL Server Database File (SqlClient)" (meaning SQL Server Express) and User Instance = True, and Integrated Security = True.

The above is working successfully on all machines except my Laptop. On my Laptop, I am getting this error "user does not have permission to perform this operation". On my Laptop, if I change User Instance = False, it works fine. Also, If I connect to SQL Server 2005 it works fine only if User Instance = False.

I tried all kind of security changes, nothing worked. For example, I setup Everyone as Full Control for the Folder and the MDF File of SQL Server. I gave my user ID as sysadmin role in SQL Server Express. Also, I enabled creating User Instance form SQL Server Express, Nothing is working.

Appreciate your help.


WebResource.axd - Padding is invalid and cannot be removed error



I'm working on a site that is hosted externally, and the admin just sent me an email syaing they're getting this following error:


Event code: 3005 

Event message: An unhandled exception has occurred.

Event time: 11/17/2008 8:11:24 AM

Event time (UTC): 11/17/2008 8:11:24 AM

Event ID: 5d3b54c09a24463ca8fb03f22692e0bb

Event sequence: 731

Event occurrence: 3

Event detail code: 0

Application information:

Application domain: /LM/W3SVC/1776482879/ROOT-1-128713348984007217

Trust level: Full

Application Virtual Path: /

Application Path: D:\....

Machine name: ****

Process information:

Process ID: 2272

Process name: w3wp.exe

Account name: ****

Exception information:

Exception type: CryptographicException

Exception message: Padding is invalid and cannot be removed.

Request information:

Request URL: http://sitename/WebResource.axd?d=_O9D297IUE-qcgMP0yFe-w2&t=633468747532779057

Request path: /WebResource.axd

User host address:


Is authenticated: False

Authentication Type:

Thread ac

What is the best practice to manage permission for confidential documents



My company have 10 types of claim forms: travel claim, business trip claim, etc

I got job to create e-form from sharepoint using infopath but the thing is how to prevent someone else to not view our claim form since it's confidential.

Im thinking to create folder like this way:

1. Claim

1.1. Travel Claim

      all staff will submit their form over here.

1.2. Business Trip Claim

      all staff will submit their form over here.

1.3. etc


a. How to prevent other people to see our own claim form

b. How to restrict only the creator, supervisor and HR can see & approve their form

Is this something that need to do with Information Right System?

SharePoint Workflow E-mail Hyperlink has the Spaces Between Two Words Are Removed

I have a very simple Workflow, that includes href link to Infopath form.
If the form name includes spaces, the URL redirects to a The Form has been Closed message, indicating that it cant find that form.
In our scenario, the file name of the document/form in SharePoint when saved is called "Travel Request - <submit date>"  as noted with spaces.
The Hyperlink URL in the email generated by the workflow appears to encode all values in the name after the first two words (after Request).  See below.  after the word Request the spaces are encoded properly.     its replacing the first space with it appears %0d%0a (CR LF)
The URL below is what is displayed when right clicking, and selecting Edit Hyperlink in the email

I can reproduce this in development and production.  Any ideas on how this can be resolved?

sharepoint 2007 permission


Hi all
1- when i create group in shrepoint 2007 i ned to determine permission for this group like users of this group have permission for specific folders and when any user login from this group the configuration of welcome page is differ
like new links appeare other not ....

2-The customer can ask to be notified when new information is updated

3- user can place files in specific folders by emailing them to specific addresses


The resource you are looking for (or one of its dependencies) could have been removed, had its name



I'm new to asp.net MVC.

When i'm running my application  I got this exception.

The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable.  Please review the following URL and make sure that it is spelled correctly


my global.asax file. is,







static void RegisterRoutes(RouteCollection routes)"{resource}.axd/{*pathInfo}");"Default", // Route name



SharePoint permission to view draft pages



I would like to create a new permission in sharepoint 2007 where all the people having this permission should be able to view the draft pages but they should not have right to edit that page or publish that page

can any one please let me know how to create a new permission which has a right to view draft pages but not edit\publish the page.

THANKS in advance u can reach me on rajesh.batchu@hotmail.com

you do not have permission to do this operation. Whenever I try to edit a page in sharepoint designe


Hi There,

I keep getting the error message "you do not have permission to do this operation" in  sharepoint designer 2007 (WSS 3.0), whenever I try to edit a page in Sharepoint Designer.

I am a farm admin, site collection admin and site admin, after the error message I can click OK and enter the Administrator password which has the same priviliges as me and it thinks about it for 5 minutes then returns the same error, eventually after several hours it will allow me to save changes but it's about a 1 in 20 chance.

As it does save sometimes it would appear to me that somehow it is losing the connection or temporarily losing the credentials. Does anybody have a clue where I can start to find out a solution to this problem. I get the feeling that something is corrupted somewhere but I don't what to look for and where.

Any help, tips, ideas gratefully received.

Thanks in advance.


Need direction on where to research to accomplish very detailed permission handling


Currently i have membership and roles setup on my site. Now what is my next step to get more specific control.

Based on what i hav now, i have my pages setup so they are visible or not and links not visible and so on. But now on a more detailed level, say im setup as a user. As a user my default permissions is just to view data.. no editing. But say someone was let go, now instead of granting me full access to everything, i need to be able to go in and provide more permissions to the account.


Add Users
Modify Users
Delete Users

View Users Detail (only the person that is logged in)

Since the the user that was let go was an admin. They had all the other options, but as a temporary thing, we need to be able to add say permission "Add Users" to the individual user account.

To accomplish this type of control, what do i need to look at to accomplish such a setup?

"Views" Listing Permission

I'm currently experiencing a problem whereas a once funtioning "view list" assigned to one of my tables is no longer displaying in the upper right hand side of said table... Additionally, when I go into "list settings" from the page and re-add the created view(s) for public viewing, it will show up on the page initially, "but" when I exit out of the page and come back to it, it's gone again! Has anyone else seen this before? JayCERTIFIED: CCNA, Network+, Security+, Server+, I.T. Project+

SQL User Permission (No answer found by searching)

Hello all!   I'm hoping someone will be able to answer my simple question!   Previously, I've run the below script to give one user access to their db in SQL management studio but nothing else. use [someDB] -- use the real db name go sp_changedbowner 'theUser' -- use the new username go 4. Next, deny the new user "public" access to ALL databases: use master go deny VIEW any DATABASE to theUser go   However I now need to add an additional user with view on permissions to the database and can't figure out how to do it. I'm sure it's simple but my SQL knowledge is at a low level.   Many thanks, Lee.

The condition of creating assembly for external access permission?

To create an EXTERNAL_ACCESS or UNSAFE assembly in SQL Server, one of the following two conditions must be met: 1. The assembly is strong name signed or Authenticode signed with a certificate. This strong name (or certificate) is created inside SQL Server as an asymmetric key (or certificate), and has a corresponding login with EXTERNAL ACCESS ASSEMBLY permission (for external access assemblies) or UNSAFE ASSEMBLY permission (for unsafe assemblies). 2. The database owner (DBO) has EXTERNAL ACCESS ASSEMBLY (for EXTERNAL ACCESS assemblies) or UNSAFE ASSEMBLY (for UNSAFE assemblies) permission, and the database has the TRUSTWORTHY Database Property set to ON. The two conditions listed above are also checked at assembly load time (which includes execution). At least one of the conditions must be met in order to load the assembly. This is a explanation on msdn.I think if only one of these condition is met,it will work. But after I do the first condition,I still can not create an assembly with EXTERNAL_ACCESS permission except SET TRUSTWORTHY on. should the two condition be met?  

System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlCli

I have created a windows library control that accesses a local sql database I tried the following strings for connecting Dim connectionString As String = "Data Source=localhost\SQLEXPRESS;Initial Catalog=TimeSheet;Trusted_Connection = true" Dim connectionString As String = "Data Source=localhost\SQLEXPRESS;Initial Catalog=TimeSheet;Integrated Security=SSPI"   I am not running the webpage in a virtual directory but in C:\Inetpub\wwwroot\usercontrol and I have a simple index.html that tries to read from an sql db but throws the error System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.   at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)   at System.Security.PermissionSet.Demand()   at System.Data.Common.DbConnectionOptions.DemandPermission()   at System.Data.SqlClient.SqlConnection.PermissionDemand()   at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, etc etc  The action that failed was:DemandThe type of the first permission that failed was:System.Data.SqlClient.SqlClientPermissionThe Zone of the assembly that fa

Restored copy of DB gives bizarre DENY permission to a dbo user

We took a backup of our PROD database and restored it in our Integration testing environment, and ran a script to alter the schema from the current PROD schema to the new schema we wanted to test in Integration testing. This same script has worked fine in two other environments and exhibited no issues. However, on our SQL cluster in the Integration testing environment, the script (which is hundreds of lines long and performs numerous things that require you to be dbo to do) fails on one line, a basic UPDATE statement on a single table.  The table has no deny permissions, and only has explicit grant permissions for the Application Role that accesses it.  Other users who are dbo can UPDATE the table.  I can UPDATE all other tables and do everything else a dbo should be able to do.  On every other SQL instance we have tried this on, it works. For some reason, this error only occurs specifically on this one instance of SQL, with my specific user, and this specific table.  I am baffled as to what could be going on, but need to get this repaired to bring our Integration testing environment back on line. What could be causing this?The Pragmatic TSQL Programmer

Insert permission was denied on Object '', database '', schema ''

i have a senario where in i am trying to insert data into a Database , i end up getting the above error 'Insert permission was denied on Object '', database '', schema '''.We have a DB which has all Storeprocedures and 90% of the tables . the remaining 10% of the tables are in a different database.I am having trouble inserting data into the second database.The storeprocedure is executed as a user who has permission on the DB and tables.Also the storeprocedure is given permission to a role in which the user is a member . The same role doesnt exists in the 2nd Database.I am able to do all DB operations in one environment . i am unable to do the same in the others.

Windows 7 CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 26

Hi I have migrated to a new computer using Windows 7, 6 gig memory, I7 chip (old machine had xp) and have installed Visual Studio 2008 and  SQL Server 2008 R2.  I get CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262) when I try to create a new database.  Other posts (example:http://social.msdn.microsoft.com/forums/en-US/sqltools/thread/28fee0ed-c7e2-40df-8f79-f513c9848f09/) work for Vista but I cannot find how to grant permissions.  Run as administrator (vista fix) does not work. I have admin privaleges on my machine.  There are no other accounts.    What do I need to do to update privaleges? Thanks and have a nice day.    
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