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

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

Permission requierd to change an object owner

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

hello all ,

i tasked to run some of scripts using ALTER.. my question is what is i but the default object owner before object name [dbo].[objectname] do i need to have an admistartion privialge on the whole instance or just need to be only db admin

View Complete Post

More Related Resource Links

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.

The SELECT permission was denied on the object 'sysjobs_view', database 'msdb', schema 'dbo'.

So, I have an SSIS package that uses a transfer jobs task between Server A and Server B.  When I run the package with my credentials, everything works fine.  However, when I run the package from an SSIS using a different user, I get the following error: Date 9/1/2010 8:00:00 AM Log Job History (xxx) Step ID 1 Server xxx Job Name xxx Step Name Run SSIS Duration 00:00:01 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:00:00 AM Error: 2010-09-01 08:00:01.39 Code: 0xC002F325 Source: Transfer Jobs Task Transfer Jobs Task Description: Execution failed with the following error: "An exception occurred while executing a Transact-SQL statement or batch.". End Error Error: 2010-09-01 08:00:01.39 Code: 0xC002F325 Source: Transfer Jobs Task Transfer Jobs Task Description: Execution failed with the following error: "The SELECT permission was denied on the object 'sysjobs_view', database 'msdb', schema 'dbo'.". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 8:00:00 AM Finished: 8:00:01 AM Elapsed: 0.75 seconds The strange thing is, the user running the job ahs sysadmin permissions

Select Permission Denied on object

Hello all, I have just begun to develop a simple web application to maintain phone book / contact details of people. I have been facing problems wrt the connection to the database, while trying to execute the reader it throws this error - Server Error in '/phonebook' Application. SELECT permission denied on object 'PhoneBook', database 'Northwind', owner 'dbo'. 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: SELECT permission denied on object 'PhoneBook', database 'Northwind', owner 'dbo'. Error occurs at - reader = cmd.ExecuteReader(); The stacktrace looks like this -[SqlException: SELECT permission denied on object 'PhoneBook', database 'Northwind', owner 'dbo'.]   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +742   System.Data.SqlClient.SqlCommand.ExecuteReader() +42   Phonebook.ResultPage.CreateDataSource() in c:\inetpub\wwwroot\phonebook\resultpage.aspx.cs:56   Phonebook.ResultPage.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\phonebook\resultpage.aspx.cs:39   System.Web.UI.Control.OnLoad(EventArgs e) +67   System.Web.UI.Control.LoadRecursive() +35    Syste

The EXECUTE permission was denied on the object 'proc_UpdateVirusInfo'

Hi All,   SharePoint 2007 x64 w/SP1, SQL 2005 x64, ForeFront for SharePoint w/SP1, running on Windows Server 2003 x64 R2 w/SP2.   We originall setup this server using only a couple service accounts. That was a bad idea so a few weeks ago I went over everything and setup or service accounts according to Microsofts recommendations. (http://technet.microsoft.com/en-us/library/cc263445.aspx)   I've gone over the requirements a dozen times and everything is set perfect.   I have two issues.   1. Randomly we have a SQL permission issue popping up, this abouts a couple times a day (some days none), the event log will fill about with anywhere from 15 to 800 of the same event.   Event Type: ErrorEvent Source: Windows SharePoint Services 3Event Category: Database Event ID: 5214Date:  3/11/2008Time:  1:28:30 PMUser:  N/AComputer: TRUMANDescription:Insufficient SQL database permissions for user 'PortalPool' in database 'SharePoint_AdminContent_45f0f48e-c1b1-463c-99e3-ea6648beaf37' on SQL Server instance 'Truman'. Additional error information from SQL Server is included below. The EXECUTE permission was denied on the object 'proc_UpdateVirusInfo', database 'SharePoint_AdminContent_45f0f48e-c1b1-463c-99e3-ea6648beaf37', schema 'dbo'. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.   PortolPool is our service account for the IIS Poo

change row-groups: Hidden-expression of deleted group-object still interferes

Hallo,    I built a report with 23 Datasets. Each of them contained the same hierarchie of two row-groups. The visibility of the subgroup depended on the value of some report-parameters. Now I need to build the same report, only this time with a different rowgroup. I already included the Datafield for the rowgroup into each dataset, deleted all old row-groups and set up the new row-group for each dataset. I also deleted the old report-parameters. The problem is, I still get Error-messages like:       "The hidden-expression of the group-object 'group2' refers to a non-existant report-parameter xy." I checked all hidden-expressions of every single tablix and everywhere the hiddenproperty is correctly set to "visible". How can I make SSRS 2008 realise that the old hidden-expressions, which indeed did refer to the now deleted parameters, are no longer existant?   Any help on this would be much appreciated. NuramonTheWanderer  

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?




EXECUTE permission denied on object 'sp_OACreate', database 'mssqlsystemresource'


HI There

I have a user login that is executing an sp. It gets the follwoing error:

Msg 229, Level 14, State 5, Procedure sp_OACreate, Line 1

EXECUTE permission denied on object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.

Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 1

EXECUTE permission denied on object 'sp_OAMethod', database 'mssqlsystemresource', schema 'sys'.

Msg 229, Level 14, State 5, Procedure sp_OAMethod, Line 1

EXECUTE permission denied on object 'sp_OAMethod', database 'mssqlsystemresource', schema 'sys'.

Can't add item using client object model of sharepoint 2010 with read only permission to user.



I have already developed Silverlight application in SharePoint 2010 using client object model.

But I have one scenario that user can comment on the item, so there is a update operation come in picture for user, but user have read only permission to site.

So please help me resolved this problem.

We can use Run with elevated privileges method in SP object model. I think Silverlight client object model don’t support this method.

Is there any alternative workaround to solve this problem?


SQL+SMO; how to get object level permission


Hello Experts,

i wrote a little application to helps me to script the whole database with their tables;stored procedures; indexes; ...
Here is my code

Dim objServer As New Server("MyServer")

Dim objDatabase As Database

Dim objCollString As System.Collections.Specialized.StringCollection = Nothing

Dim objFile As New FileStream("c:\Documents and Settings\USER\Desktop\CreateAlyceDatabaseByApp.sql", FileMode.Create, FileAccess.Write)
Dim objFileWriter As New StreamWriter(objFile)
objFileWriter.BaseStream.Seek(0, SeekOrigin.End)

            objServer.ConnectionContext.LoginSecure = True
            objDatabase = objServer.Databases("myDataBase")
            objCollString = objDatabase.Script()

            For Each strScript As String In objCollString
            objFileWriter.WriteLine("USE [" & objDatabase.Name & "]")

            'SCRIPT SCHEMAS
            objFileWriter.WriteLine("-- SCHEMA SCRIPTS")
            For Each objschema As Schema In objDatabase.Schemas
                If Not objschema.Name.StartsWit

How to check who is the person that change the list permission or the list item permission?


Does SharePoint out of the box has any reports that report the change of permission to list/list item?

User A change the permission of List Item A by adding a new user
User B change the permission of List Item A by removing a user

Thank in advance.

Change Control - Who changed this object?

We have a team of DBAs. A maintenance plan was changed last week, we can see
a new modified date, but who made the change?
In the wider question - is it possible to log which users are making changes
to objects in SQL server 2005?
Gerry Hickman
London (UK)

EXECUTE permission was denied on the object 'proc_putObject',



I am getting the following error, while I try to take the backup of sharepoint application.

EXECUTE permission was denied on the object 'proc_putObject',


Srikanth Reddy

The SELECT permission was denied on the object 'aspnet_Membership', database 'Employee', schema


I am having IIS server and SQL server on two different machines. 

In the SQL server I created a new user using the SQL Authentication.

In my application I am using a connection string like this:

<add name="UsrConnectionString"
      connectionString="Data Source=\GEOGSQL;Initial Catalog=ITAM; 
      User Id=itam; 
Password=itam_web;" providerName="System.Data.SqlClient" />

<add name="UsrConnectionString" connectionString="Data Source=x.y.z.w\instancename;Initial Catalog=Employee;  User Id=xyz;  Password=xyz;" providerName="System.Data.SqlClient" />

I can access the other tables within the Employee database. But I am unable to access the tables created by ASP.NET autom

Change database owner using Alter Database 2008



I need to change the owner of a bunch of databases, and I do not want to use sp_changedbowner as it is deprecated for the next sql releases. I there a way to do this in an Alter Database statement?

Any help would be appreciated


Dave SQL Developer

how to get current user permission,all permissions in share point site using object model



how we will get current user permission using object model to a site/subsite

how can show all permission under a subsite in share point.




Can't change print job owner with SetJob()



I’m developing a program that must be able to submit a print job and change the Owner of the job before it goes into the spooler. The problem is that the username don’t change when the print job is submitted. I’m running the program as the administrator account.

My code is working because if I try to change another field under JOB_INFO_2 structure like pNotifyName it does work. I also tested my program on a Windows XP SP3 machine and yes, the owner changes.

In the manual for the SetJob() function is says:
“The following members of a JOB_INFO_1, JOB_INFO_2, or JOB_INFO_4 structure are ignored on a call to SetJob: JobId, pPrinterName, pMachineName, pUserName, pDrivername, Size, Submitted, Time, and TotalPages.”. This is strange because it used to work in Windows XP.

If this is true that I can’t change the Owners username, if so how can I do it  ?

Edit: It doesnt work on Windows 2008 Server either

Windows 7 x64
Visual Studio Pro 2008 sp1

The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'.


I am getting the following error when I execute an SSRS report.

The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'.

The report is executing a stored proc. Which in turn is running an Agent Job.

When I run this report through BIDS it works fine. It is only when I run it though Report Manager I get a problem.

Can anybody help?

Mr Shaw
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