Issue assignning default database

[niall5098]

HI All,

I have just restored a database onto a cluster, no problems there, now i want to create a user that can be used to access the data in that database.

I create a user in sql server security section, assign the database as the default database and map the database but when i log in i can't see the objects.

Anyone seen this before?

Thanks

 

[niall5098]

got it sorted

sp_changedbowner