t-SQL grant permission for table drop and create

Posted by Melody Friedenthal on Stack Overflow See other posts from Stack Overflow or by Melody Friedenthal
Published on 2010-03-17T19:38:10Z Indexed on 2010/03/17 19:41 UTC
Read the original article Hit count: 495

Filed under:

grant

|

drop

|

table

How can I Grant some users permission to drop and create a single table only in the SQL 2005 database accessed by our VB.net 2005 Win app?

Some articles suggest Granting Control rights to the table but I cannot make this work. If you think this is teh way to go, can you show me the correct syntax?

© Stack Overflow or respective owner

Related posts about grant

SQL SERVER – Difference Between GRANT and WITH GRANT

as seen on SQL Authority - Search for 'SQL Authority'
This was very interesting question recently asked me to during my session at TechMela Nepal. The question is what is the difference between GRANT and WITH GRANT when giving permissions to user. Let us first see syntax for the same. GRANT: USE master; GRANT VIEW ANY DATABASE TO username; GO WITH GRANT: USE… >>> More
Fixing my SQL Directory NTFS ACLS

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
I run my development server by boot to VHD (Windows Server 2008 R2 x64). In that instance, I also have an attached VHD (I attach via script at boot up time using Task Scheduler). That VHD I have my SQL instances installed. So, the other day, acting hasty, I chmod my ACLS – wow, what a day after… >>> More
SQL SERVER Difference Between GRANT and WITH GRANT

as seen on Dot net Slackers - Search for 'Dot net Slackers'
This was very interesting question recently asked me to during my session at TechMela Nepal. The question is what is the difference between GRANT and WITH GRANT when giving permissions to user.Let us first see syntax for the same.GRANT:USE master;GRANTVIEW ANY DATABASETO username;GOWITH GRANT:USE… >>> More
Grant root access without having grant access with mysql

as seen on Server Fault - Search for 'Server Fault'
In attempts to learn more about apache and mysql, I've been fiddling with my local environment. Fun times. Of course, this leads to my screwing things up. So, thanks for being there. Recently, I messed up a bit in mysql. I currently don't have a root user, and the users I do have don't have grant… >>> More
Egy klassz ADF eloadás

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Túl vagyunk a Technology Forum rendezvényünkön, és én azt gondolom nagyon hasznos volt. Grant nagyszeru eloadást tartott. Címe Forms to ADF: WHy and How. Szerintem maga a demó, ami persze nem letöltheto igazán hasznos volt nem csak Forms háttérrel rendelkezo fejlesztok számára is. Sok rendezvényünkön… >>> More

Related posts about drop

How to speed up this simple mysql query?

as seen on Programmers - Search for 'Programmers'
The query is simple: SELECT TB.ID, TB.Latitude, TB.Longitude, 111151.29341326*SQRT(pow(-6.185-TB.Latitude,2)+pow(106.773-TB.Longitude,2)*cos(-6.185*0.017453292519943)*cos(TB.Latitude*0.017453292519943)) AS Distance FROM `tablebusiness` AS TB WHERE -6.2767668133836 < TB.Latitude AND… >>> More
Why can blocked IPs get through my iptables? What's wrong with this configuration?

as seen on Server Fault - Search for 'Server Fault'
(Why can/How are) blocked IPs (get/getting) through my iptables? Hello and thanks for your consideration... I have configured iptables and included (below) output from the command "iptables --line-numbers -n -L" yet IP addresses (like 31.41.219.180) from IP blocks I have already blocked are getting… >>> More
SQL Server script commands to check if object exists and drop it

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Over the past couple years I’ve been keeping track of common SQL Server script commands that I use so I don’t have to constantly Google them. Most of them are how to check if a SQL object exists before dropping it. I thought others might find these useful to have them all in one place, so… >>> More
Flex - Drag and drop - Drop a subset of multiple items

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm developing two DataGrid with drag and drop support. Multiple items can be selected from the source data grid, and dropped into the target data grid. I'm using an drag and drop event listener which completes the operation only in certain cases. I'm using event.preventDefault() but it doesn't… >>> More
iptables rules keep showing up

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I just installed an ubuntu precise server, after a few weird communications issues I checked the iptables list and found: Chain INPUT (policy DROP) target prot opt source destination ACCEPT all -- anywhere anywhere ACCEPT all -- anywhere… >>> More