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 |
|
ketu0001
Starting Member
11 Posts |
 Posted - 2007-06-15 : 06:28:45
|
HiFor MSSQL 2005 server, when we create new user using stored procedure sp_grantdbaccess, it creates schema with name given to user. While when we create new user with query " Create login identfied by'password'. It attach user to default schema at the server.  My question is can we have a default schema assigned to the user, while user is created with sp_grantdbaccess?Is there any way to do so?Please reply as early as possible. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-15 : 15:11:33
|
| It will be removed in a future version of Microsoft SQL Server. |
 |
|
|
ketu0001
Starting Member
11 Posts |
Posted - 2007-06-18 : 02:33:36
|
| What I want to achieve is -I am using sp_grantdbaccess in product. Customer's wish is to attach newly created users to default schema.Is there any workaround for the same? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-18 : 16:05:08
|
| Use 'with default_schema' option in 'create user'. |
|
|
|
|
|
|
can sp_grantdbaccess attach user to default schema