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


Post New Web Links

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

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
 
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


View Complete Post


More Related Resource Links

Copy User permission

  

Hello,

i would like to copy the permissions from user to another user at sql 2008.

All database permssions should also be copied.

Are there a way to do this with a script or anything else,

Horst


Thanks Horst MOSS 2007 Farm, MOSS 2010 Farm, TFS 2008, TFS 2010

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.

Tarek.


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.

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. I am using Windows Authentication mode in SQL Server Express. 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. I am already added to the Administrator Group locally on my Laptop. Still same problem. Checked this article: http://msdn.microsoft.com/en-us/library/ms254504.aspx, same problem. I enabled User Instances and also tried to Disable User Instances. When I disable user instances, and then try to connect from VS, I get a different error, which is asking to enable user instances.

user permission in granula level in SharePoint version 2

  
Hi, everyone:   I am administrator of a SharePoint v2 site. I found that I can either give "view item" or "view item, insert item, remove item and update item" permission to users, no middle. However, I do wish to give some users "view, edit" permission, but no "insert and remove item" permission.   So, does SharePoint v2 support this in out of box feature? if yes, how to make it, if no how can we achieve in easiest way?   Thank u MySTfrom Finland :D

Errors attempting to process SSAS Cube. I get Either user does not have permission to create a new o

  
Hi All, One of my production server deployed cubes i am not able to process the cube.When i tried to process the cubes i will get an Error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Either the 'NA\gsad478' user does not have permission to create a new object in 'JNJAUSYSVR01', or the object does not exist.  (Microsoft.AnalysisServices)   Over the source server i do have sysadmin access and also  i have added read only role of particular cube. I right click on the database and tried to create new database of SSAS that also thrown with same error. Please help me in this regard.   Thanks, Gangadhar

limitate user permission to edit other users documents

  
i have a list where everybody uploads documents, but i want that only the user that uploaded the document can edit it or delete it, is there a simple way without workflows or code? thanks!

User permission error

  
I have a VS 2010 website that is reading and writing to a SQL Server 2008 filestream. By filestream, I mean that I have a table in a SQL Server 2008 database that is configured for filestreaming (ie - the table has a RowGuid column and a varbinary(MAX) column that is filestream enabled). The website is able to read and write to the filestream just fine and has been doing so for months now. However, there is one minor detail about using the filestream that has plagued me since the beginning, and were it not for a hack - at least I consider it to be one - then my filestreaming would not work. The problem is that for some reason when my website makes a connection to the filestream (via the .NET SqlFileStream class) it always attempts to authenticate with the name of the webserver.For example, I have a brand new web server called WebSrvPrd01 that I just placed my website on (the one that is using the filestream). When I try to do anything that uses the filestream (either writing or reading to) it throws the following exception:Login failed for user 'SUPER-NT\WebSrvPrd01$'.At this point, I then have to go into SQL Server and add the domain and user SUPER-NT\WebSrvPrd01$ to the database and give them access rights accordingly. After having done so the website will have no problems and the filestream works wonderfully. However, I don't like this solution! It presents a bit

Permission to use User Solution in Site Collection

  
Hello, is it possible to deploy a user solution in a site collection, and set permissions which users or groups can use the solution in the site collections or subsites in the site collection ?    

GRANT permission on schema to user in SQL 2000

  
Hi,I am using following statement to grant specified permissions on schema to a user in SQL Server 2005. GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE on ::[Schema Name] to [My DB User]I need to perform the same in SQL 2000. However, this does not work in SQL Server 2000. Is there any equivalent syntax which can be used in both (SQL 2000 & 2005).Thanks in advance...

Restricting user permission to upload doc but not create new folder

  

Hi all,

was wondering if it's possible to allow a user to upload documents but not be able to create a new folder...

Any help is greatly appreciated.

thanks


Give permission to all users of a customized sharepoint portal, where all the user controls of the w

  
Hello there

I have created a sharepoint portal and customized it. I have created my own master page and there are many webparts implemented. This has been hosted in a MOSS server. When a normal user is trying to access the portal first thing in the morning, he is getting a "You are not authorized to view this page" error. But when a site admin access the site, there is no issue and he is able to access the site. The site admin does nothing in the site and once he has logged in to the site,  the user is able to access the site without any trouble.


I have found what was causing the issue. But dont know whats the fix for it.

The issue is...We were trying to place all the usercontrols created as part of our application in a seperate folder under ControlTemplate folder. This is what was not allowing the users who are not site admins. But it was ok, when the admin first accesses the same.

WHat is the fix for this ... to make the new folder accessable to all users ??

Kindly help...

"Use Social Features" permission in "User Profile Service Application"

  

Hi,

We wish to disable the "Tags and Notes" feature on our SharePoint 2010 site.  When I remove the "Use Social Features" permission from the "User Profile Service Application" this also removes the "My Site" link from the drop down at the top of the page.

Why on earth would this happen?  According to the TechNet page on social features (http://technet.microsoft.com/en-us/library/ee721063.aspx) the Use Social Features permission "Includes social tags, Note Board, and ratings."  Nothing in there indicates that it would remove the link to My Site.

My Site continues to work of course, it is just that the link is removed (which confuses users).

We want to disable Tags and Notes but leave the link to My Site.  Is there a way?

Thanks,
David


User does not have permission to perform this action( Microsoft SQL Server, Error:15247)

  

Hi,

I was able to do my work with ease on my Database server, until sometime Friday evening. Don't exactly know what transpired, only that I can now no longer run queries or even create new databases. Here is a sample of what happens when I try to create a database

Create Database PetitionSample

Msg 262, Level 14, State 1, Line 1

CREATE DATABASE permission denied in database 'master'.

I used to be able to create databases, create new users and so on. My Server is installed on a Vista machine and I am running Developer version and using Management studio 2008 to access it. Anyone have any idea what could be going on?


None

How to use Multiple masterpages depending on the user permission

  
Hi, I am having Two master pages in sharepoint 2010 RTM enterprise

one mastepage has to be load when site admin has logged in\

other masterpage has to be load when 'other than'  site admin is logged in

For doing this req,I created feature activated event i done through this object model.


But this is working only when feature activated(1 time only).Not based on the logged in user


If i deactivate and activate again it will start working(load mastepage) one time only.
As I know, feature  will perform the action .once the site is open then it will start.

As per my requirement Before page loads my code has to work.


I also created Httpmodule,written Init method,but it also not working....Is there any other procedure i need to follow for doing this.Please help me.

How to use Multiple masterpages depending on the user permission

  
Hi, I am having Two master pages in sharepoint 2010 RTM enterprise

one mastepage has to be load when site admin has logged in\

other masterpage has to be load when 'other than'  site admin is logged in

For doing this req,I created feature activated event i done through this object model.


But this is working only when feature activated(1 time only).Not based on the logged in user


If i deactivate and activate again it will start working(load mastepage) one time only.
As I know, feature  will perform the action .once the site is open then it will start.

As per my requirement Before page loads my code has to work.


I also created Httpmodule,written Init method,but it also not working....Is there any other procedure i need to follow for doing this.Please help me.

Copy images to page layout or to wiki page - looking for the user-friendly way of work!

  

Hi,

I found that when copy & paste text and images (from internet site / from word etc.) -

when i'm coping to page layout as "Article Page"  - all the content include images is pasted at once and no farther configuration is needed.

When i'm coping to a wiki page - the images are not always being copied and i have to define the target images library it will be kept in (which makes the edit of wiki page more complex and less user-friendly).

Am i missing something? should i configure something in the "page content" field of the wiki page? or activate any site feature?

thanks


Categories: 
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