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 Shaw
SQL 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