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.
| Author |
Topic |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2012-06-28 : 07:02:06
|
| I have limited access to a particular SQL Server 2008. A database has been setup for me and I need to be able to create tables and populate them with data. I'm told my login has been assigned dbo privileges but if I go into SSMS and try to create a table I get a warning - "You are not logged in as the database owner or system administrator - You might not be able to save changes to tables that you do not own. Certain edits require CREATE TABLE permission"If I continue I get a message saying I don't have CREATE TABLE permissions. What's missing here? I'm guessing the permissions aren't set correctly but what exactly do I need (preferably as a script please)?thankssteve-----------Insanity: doing the same thing over and over again and expecting different results. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-06-28 : 07:06:38
|
I'm told my login has been assigned ...Did you tell them what you have posted here?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2012-06-28 : 07:51:25
|
| EXEC sp_addrolemember 'db_owner' , 'elwoos'GOAlso, kick them in the shins as hard as you can.. |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2012-06-28 : 08:47:11
|
quote:
Originally posted by RickD
EXEC sp_addrolemember 'db_owner' , 'elwoos'GOAlso, kick them in the shins as hard as you can..
Hee hee fair enough, I wondered if there was something else that I had overlooked. To be fair the guy who did it is usually very good-----------Insanity: doing the same thing over and over again and expecting different results. |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2012-06-28 : 10:13:19
|
| I'm told confession is good for the soul :)-----------Insanity: doing the same thing over and over again and expecting different results. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2012-06-28 : 11:32:47
|
quote:
Originally posted by elwoosHee hee fair enough, I wondered if there was something else that I had overlooked. To be fair the guy who did it is usually very good-----------Insanity: doing the same thing over and over again and expecting different results.
Unless he has revoked rights for db_owner (not even sure if this is possible). |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2012-07-02 : 06:04:54
|
quote:
Originally posted by RickD
quote:
Originally posted by elwoosHee hee fair enough, I wondered if there was something else that I had overlooked. To be fair the guy who did it is usually very good-----------Insanity: doing the same thing over and over again and expecting different results.
Unless he has revoked rights for db_owner (not even sure if this is possible).
No it was an oversight.-----------Insanity: doing the same thing over and over again and expecting different results. |
|
|
|
|
|
|
Something is missing here...