dont drop and delete - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

dont drop and delete

Author

Topic

kiruthika
Yak Posting Veteran

67 Posts

Posted - 2007-12-10 : 06:51:38

Hi!

I've one table named mytable. I dont want to drop and delete
this table? How can i achieve this ?
Please help me out!

Thanks!

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-12-10 : 06:52:25

quote:
I dont want to drop and delete

so what do you want to do with that table ?

KH
[spoiler]Time is always against us[/spoiler]

Paul Skinner
Starting Member

9 Posts

Posted - 2007-12-10 : 06:54:39

Do you mean you *do* want to drop and delete it?

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2007-12-10 : 06:56:36

are you talking about user permissions? i.e. you want to stop users / a usergroup from deleting / dropping the table?

Em

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-10 : 06:57:22

quote:
Originally posted by kiruthika

I dont want to drop and delete this table? How can i achieve this ?

Do nothing.

E 12°55'05.25"
N 56°04'39.16"

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-12-10 : 06:58:02

Hey this is fun. Let's guess what the OP wants or don't want

KH
[spoiler]Time is always against us[/spoiler]

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-12-10 : 07:04:17

[code]Begin Tran
Drop Table <table-name>
Rollback Tran[/code]

Note: Isn't this a nice way to impress your boss by showing hardcore code which does nothing?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

kiruthika
Yak Posting Veteran

67 Posts

Posted - 2007-12-10 : 07:09:25

Hi!

I agreed elancaster.........

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-12-10 : 07:11:02

And . . . . . we have a winner

KH
[spoiler]Time is always against us[/spoiler]

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-12-10 : 07:12:48

Set permissions as DATAREADER/DATAWRITER for the users you want to block. They are still able to select/delete/update/insert data to and from the table, but they can't drop the table.

E 12°55'05.25"
N 56°04'39.16"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources