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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-12-22 : 10:37:56
|
| Hi,I created sql server login on sql server 2005. I added this login to a user database and public role is assigned by default. I granted create table privilege on this db with 'grant create table to <usernaem>' command. After that I logged in with this user credentials. When I tried to create table in this database I got following error:"Msg 2760 - The specified schema name "dbo" either does not exist or you do not have permission to use it."I just want to give user to create table in this db not other permissions, how to do it? Thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-12-22 : 10:44:04
|
| What's the user's default schema?--Gail ShawSQL Server MVP |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-12-22 : 11:52:56
|
| User's default schema is dbo. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-12-22 : 14:24:09
|
| Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database. I don't want to give drop or alter permission. User should be able to only create tables. |
|
|
|
|
|
|
Msg 2760