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 |
|
parkerst
Starting Member
4 Posts |
 Posted - 2011-11-29 : 03:39:29
|
| Hi All,I have set up a user on my SQL Server that has DB_OWNER rights to a single database within my server (with many DB's), However, when this user attempts to open SMSS and then the "Databases" tab of SMSS, he gets an error saying unable to access database A....The only database he has permission to access starts with G.If its relevant, this user can also see a list of database names in the dropdown in the top left of the SMSS consoleAny ideas how I can set up the user so that he can use SMSS normally and only see his database?Regards,Steele |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-29 : 03:42:24
|
| i think you've not changed his default db. right click on user and make db A as his default in default databse dropdown------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
parkerst
Starting Member
4 Posts |
Posted - 2011-11-29 : 03:43:06
|
| Default database is definately set for the login of this user.Edit: I just tried logging in as this user and yes, the default schema is set. Hitting new query immediately directs the user to this schema. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-29 : 03:47:10
|
quote:
Originally posted by parkerst
Default database is definately set for the login of this user.Edit: I just tried logging in as this user and yes, the default schema is set. Hitting new query immediately directs the user to this schema.
not default schema. i'm teling about default database------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
parkerst
Starting Member
4 Posts |
Posted - 2011-11-29 : 03:47:57
|
| Sorry, I should have clarified: I checked both. |
|
|
|
parkerst
Starting Member
4 Posts |
Posted - 2011-11-29 : 04:17:43
|
| Nevermind, it looks like this is due to my lack of updated SMSSthankshttp://connect.microsoft.com/SQLServer/feedback/details/354322/ssms-2008-database-list-tries-to-default-to-a-database-on-sql-server-2005 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-29 : 06:49:15
|
| oh ok------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
User with access to limited Databases