How to get rid off it?

Question

Post reply

How to get rid off it?

Charmer

SSChampion

Points: 14903
More actions
November 29, 2011 at 6:41 am

#263756

Hi Frndz,
Last week i was about to play with my client system...i was trying to create a table and alter some columns in another table....eventually i was going to drop the table which i created ...But the difficulty that i found was the SQL didn't let me do to create or alter or drop a table...is this possible to restrict so..?
How can i get rid off this kinda issue to achieve my task..?
Thanks for any information
Thanks,
Charmer

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

Tom257 SSChampion Points: 11543 More actions · Answer 1

What is the error when you try create table in ssms?

Lowell SSC Guru Points: 323518 More actions · Answer 2

Charmer (11/29/2011)
...SQL didn't let me do to create or alter or drop a table...

that's kind of vague; did you get an error due to permissions, because you didn't have priviledges, or did you get an error due to foreign key constraints, or what?

can you give us the exact error you get that prevents you from doing the create or drop or whatever?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Charmer SSChampion Points: 14903 More actions · Answer 3

The error was "you don't have permission to create or drop a table"...i remember it was not exactly but something like that...

Thanks,
Charmer

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 4

Charmer (11/29/2011)
The error was "you don't have permission to create or drop a table"...i remember it was not exactly but something like that...

It simply means you can't do it... 😛

Cadavre SSC-Forever Points: 41690 More actions · Answer 5

Ask your DBA for permissions.

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 6

Tom Brown (11/29/2011)
What is the error when you try create table in ssms?

That's a permissions issue. Were you logged in under a different account? Did your access get changed? Please tell me you're experimenting on a development server and not the production server.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Charmer SSChampion Points: 14903 More actions · Answer 7

yes i was working on a development server not production.....

Thanks,
Charmer

Charmer SSChampion Points: 14903 More actions · Answer 8

Dev (11/29/2011)
Charmer (11/29/2011)
The error was "you don't have permission to create or drop a table"...i remember it was not exactly but something like that...
It simply means you can't do it... 😛

Thanks Buddy...good joke....

Thanks,
Charmer

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 9

Charmer (11/29/2011)
Dev (11/29/2011)
Charmer (11/29/2011)
The error was "you don't have permission to create or drop a table"...i remember it was not exactly but something like that...
It simply means you can't do it... 😛
Thanks Buddy...good joke....

Actually, I was not joking. If you don't have permissions, you can't do it.

GSquared SSC Guru Points: 260824 More actions · Answer 10

Depending on your role, and possibly on specific permissions for your login or any groups your login is part of, you either need to be granted permission to create and drop objects, or you have been denied permission to create/drop objects.

Take a look at GRANT: http://msdn.microsoft.com/en-us/library/ms187965.aspx

and DENY: http://msdn.microsoft.com/en-us/library/ms188338.aspx

and REVOKE: http://msdn.microsoft.com/en-us/library/ms187728.aspx

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Charmer SSChampion Points: 14903 More actions · Answer 11

yeh...the thing which i am looking for is, how do they restrict a database for any alteration... ?

because i could select and update any records...but i couldn't alter any columns...

was it any account problem or can we restrict a database for multi-user like that..? that's what i am asking for?

Thanks,
Charmer

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 12

Charmer (11/29/2011)
yeh...the thing which i am looking for is, how do they restrict a database for any alteration... ?
because i could select and update any records...but i couldn't alter any columns...
was it any account problem or can we restrict a database for multi-user like that..? that's what i am asking for?

Yes. You are controlled by Permissions and all the scenarios that you framed here are possible with proper user access management.

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 13

If you get time, please visit following. You will find various levels of permissions.

GRANT (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms187965.aspx

GSquared SSC Guru Points: 260824 More actions · Answer 14

Charmer (11/29/2011)
yeh...the thing which i am looking for is, how do they restrict a database for any alteration... ?
because i could select and update any records...but i couldn't alter any columns...
was it any account problem or can we restrict a database for multi-user like that..? that's what i am asking for?

The data on that is answered in the articles I posted links for.

It's very, very easy to grant the ability to read data, without granting anything else. Can be restricted to certain tables, even.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon