.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

Deny Access to a number of tables.

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :ASP.Net


I have set up a SQL Role and denied SELECT, INSERT, UPDATE, DELETE access to a number of tables.

I noticed that a user in this role can create a stored procedure containing a SELECT, INSERT, UPDATE or DELETE statement on the table that I have denied access to.

How could I stop the user in the role from being able to create/alter/execute stored procedure which use the tables than I have denied access to?

Also, the user in the role needs to be able to execute stored procedure on the tables which they are not denied access to.

Any help is appreciated.


View Complete Post

More Related Resource Links

Data Points: Deny Table Access to the Entity Framework Without Causing a Mutiny


Julie Lerman shows database administrators how to limit access to databases from the Entity Framework by allowing it to work only with views and stored procedures instead of tables-without impacting application code or alienating developers.

Julie Lerman

MSDN Magazine August 2010

InfoPath and Access - two parent tables and one child table


Hi there,

I'm trying to link an InfoPath form to an Access database, I want to connect the InfoPath form to 3 tables in the Access database but InfoPath will only recognise parent-child relationships in a series (e.g. the "Company" table is the parent to the "Customer" table, which is again parent to the "Orders" table)

I need to have two parent tables and one child table, though (e.g. "Customer" is parent to "Orders", but "Inventory_Item" is also parent to "Orders"). Is there any way to establish this in InfoPath? I'm using Windows XP, InfoPath 2007 and Access 2007.

Cheers, Patrick

Importing Access 2010 tables to SQL Server 2008 R2

I'm trying to import a series of Access 2010 tables to Sql Server 2008 R2.  The Access import drivers are for *.mdb (which if I recall was the file extension for Access when I was a kid, and don't recognize the .accdb file extention).  Similarly, the Excel driver is for Excel 2003.  Isn't there a driver and method to import directly to SQL 2008 from Access 2010? SQL is installed on my server, but Access is not installed on the server.  When I copy the file onto the server and try and open it directly into SQL, I get a 'no editor installed' error. I can't get the 'upsize' wizard to work becuase it won't open the connection to SQL, even though I enter the userid and password of the SQL DB owner.  I get the following error: ===================================================== Connection failed: ============================================================= I have to say I'm stumped.  The rest of the Office 2010 suite works really well together - perhaps I'm missing something very simple? Thanks!     I guess I could export my tables as Excel 2003 and then import them using Integration Services, or install SQL Express on my laptop and 'upsize' to that instance, but SQL State: ‘0100’ SQL Server Error: 11004 [Microsoft][ODBC SQL Server Dirver][TCP/IP Sockets]ConnectionOpen (Connect()). Connection failed: SQL

Access Control List tables in sql server 2005

Hi all, Can anybody help me in creating Acl tables.how to create them in sqlserver 2005 and how to use in my .net application

Access Control List tables in sql server 2005

Hi all, Can anybody help me in creating Acl tables.how to create them in sqlserver 2005 and how to use in my .net application

How to find the Number of Tables Present in an XML File?

Dear All,Can any one let me know "How to find the number of Tables present in a XML Schema File"?Thanks and Regards,G.V.N.Sandeep

Synchronizing two tables on two databases with a dataset - MS Access



I have a C# problem I need to synchronize two MS Access tables from two different databases(two databases over a network) which is quite similar, I thought of using two different OleDbConnections and two DataAdapters to fill a Single DataSet and then manipulate the data in the DataSet, I think the source table (database with the primary data) should be loaded first (into the DataSet) then the secondary table from the remote database should subtract the existing records in the DataSet to get the difference then the difference should be Appended to the remote table, but I don't know how to remove the same records from the DataSet and to send the remaining records to the secondary database.

Here is some code I already have, but I don't know how to get this to work:

        private void btn_update_Click(object sender, EventArgs e)

        private void UpdateExperiment()
            OleDbConnection connSource = new OleDbConnection();
            OleDbConnection connDest = new OleDbConnection();
            OleDbDataAdapter daSource = new OleDbDataAdapter();
            OleDbDataAdapter daDest = new OleDbDataAdapter();
            OleDbCommand commSource = new OleDbCommand();
            OleDbCommand commDest = new OleDbCommand();
            DataSet ds

How to create a condition and policy to deny access based on host name



With SQL Server 2008 Enterprise, can I prevent an Active Directory Account Login ( domain\user ) from connecting if its coming from a host_name?

What I really need to do is this:  


On SQL1, login mydomain\user1 is only allowed to login from servers APP2, APP3, and APP4.


If mydomain\user1, though it has a login on SQL1 attempts to connection any other hostname besides APP2, APP3 or APP4 I want to deny it access to SQL1.


Can anyone point me in the right direction for the correct condition(s) for a policy that would work?



Erik A. Grob, MCITP, MCDBA

How to add a Database Connection on Sharepoint Designer 2007 to access SQL 2005 tables?


I've tried and looked on many sites with different solutions for which non of them resolved my issue. I've a blank Sharepoint site and want to view data from an SQL DB. It says that a Server Error occurred and that the Data Retrieval Service didn't worked out while listing the DB's.

I tried using the 3 methods... using the also the connection string in different ways... when I do it using VB, Office and Java... I can see the data from that DB... why on Sharepoint Designer it doesn't? It supposed to be more easier than other tools.

I'm really desperate. Any help is very welcome.



restore site failed --access deny


Hi, I just configured SharePoint Site Recycle Bin based on http://governance.codeplex.com/wikipage?title=SharePoint%20Site%20Recycle%20Bin&referringTitle=Home

when I run the commond stsadm - restore -url http://samplewebsite.ca/testing -filename e:\backup \sites\testing site.bak -force. It shows access deny.

I login as farm adim to run this.


Please help!



Access 2007, SQL 2008 and linked tables


I have a bunch of databases running on a SQL server 2008 instance.  They're all set to the default Latin collation, and the server is set to UK English locale.


I have an access database using linked tables to the SQL server.  The lcal PC is Windows 7 and also set to English UK locale.


However, the date fields in the SQL server tables are interpreted by Access as "text" type, not date.  When I type a date into them in standard UK english format - dd-mm-yyyy, access accepts them but the SQL server rejects them because for some reason it is wanting to store the data in the format yyyy-dd-mm.


I realise I'm no expert, this is probably something really simple and I'm probably being stupid, but can anyone shed any light on WTF i going on here and why, and how I fix it.  I realise I could code in access forms something to force the date into yyyy-dd-mm format and re-interpret it to English when I want to display it, but that's clunky and horrible.


Any ideas gratefully received.  Thanks.

Help with authorization in web.config to deny access to files in a folder



I have a web site that has a folder called Files that contains PDF files.  These PDF files should not be accessible to people who have not signed in to the web site. 

The login URL is www.mysite.com/Account/Login.aspx and the register URL is www.mysite.com/Account/Register.aspx. 

Once the person is signed in they can go to www.mysite.com/Documents/Documents.aspx.  This page has a gridview that lists the PDF files in the Files folder with a link to them.  If the person is not signed in, he/she can't view this Documents.aspx page.  However, if anyone has the URL to the PDF files, they can view those files without having to sign in.

How can I prevent someone from accessing the PDF files in this folder?

The site is hosted on GoDaddy using IIS 6.0.

Thanks in advance.

SQL Server : How to deny access?



I want to ask how to deny users to delete tables or more specifically deny DML statements but allow DDL statements in database.

It's urgent.

Satya Prakash Jugran

Loading from multiple Access 2007 tables



I have a requirement that i have to load data from multiple access tables in a database with same structure into sql server table having same structure of source.

Please some one help.



How to open More then one lists of sharepoint 2010 as a tables in access 2010 data base


Hi  friends  this is siddiq ,

                                   How can i open sharepoint 2010 lists in access 2010 as tables in 1 data base.I have 2 lists which i want to take into access but both of the lists are creating a seperate  database.But i want to take  both the lists  in one access database 

Mohammad Siddiqali

get the number of user wich access to the site tel now



i want to know the number of users

wich access to my site and show it



Insert NULL values into Integer column in Access 2007 tables

hi  there:

  My source data  is below and it's in CSV format

Days waited


My destination is a Number column in a 2007 access table  and the required property is set to NO

First question :

   I used a Data conversion task in DFT to convert [DT_STR] to Integer as SSIS seems to default the source as DT_STR type. However, SSIS keeps complaining that

"The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data."

I know that's because of those NULL values. how to solve this issue?


--Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --
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