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


Top 5 Contributors of the Month
Easy Web
Imran Ghani
Post New Web Links

sys.dm_fts_parser permission?

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server
 

Running the following search in SQL 2008 under my asp.net user context:

 

select * from sys.dm_fts_parser('FORMSOF(FREETEXT,' + 'DISCREPANCY' + ')', 1033, 0, 0)

 

Gives me this error:

Msg 297, Level 16, State 1, Line 1

The user does not have permission to perform this action.

 

Works fine if I run as SA but i really really don't want to have my web app run as SA to get this query to work....  Is there some small grained permission I can grant to my asp.net user to get this query to work?

 

thanks

 

 




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.

Tarek.


What is the best practice to manage permission for confidential documents

  

Hi,

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

Question:

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

Thanks


SharePoint permission to view draft pages

  

Hi,

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.

Example:

Admins:
Add Users
Modify Users
Delete Users

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=2.0.0.0, 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.    

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.

Help!!!! Permission issue with Analysis Services on Windows 2008 R2

  
Hi I'm with a project using Sql Server 2008 on Windows Server 2008 R2. It seems I can not connect to Analysis Services server with SA acount but only with Windows Authentication (The 'Authentication' option is diabled). And when I connect to Analysis Services with my windows acount , I do not have the permission to either create a database (ERROR:Either '***' user does not have the permission to create a new object, or the object does not exist) or grant server privilege to my windows account (ERROR: Only an administrator can make changes to server properties). Also, I failed to remote connect to Analysis Services on Server with my windows account (But I can remote connect to Database engine). Any idea?  Thanks!

access denied execute permission (how to resolve?)

  
hi theremy company create for me a new database in new server hostingthe problem is that with new user's database, i cannot execute SPit return error that the user "username" do not have execute permissionthe actual permission are :db_datareader,db_written,db_ddladminit seems not enoughtmust i ask for add  db_owner schema rom to user?
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