Permission Issue in SQL Server

I have a server containing three databases and one sql server
authentication user login which
has permission to three database in it.
Although I give him datareader, datawriter, public, dbowner
permission
on all three databases,

It only has permission to the database which
is mentioned as default database in the general tab of that user
role. The
other two database doesnt have the permission. Can anyone tell me
the solution of it.

Thank you

JIGAR PATEL ( ) writes:
> I have a server containing three databases and one sql server
> authentication user login which
> has permission to three database in it.
> Although I give him datareader, datawriter, public, dbowner
> permission
> on all three databases,
>
> It only has permission to the database which
> is mentioned as default database in the general tab of that user
> role. The
> other two database doesnt have the permission. Can anyone tell me
> the solution of it.

Which version of SQL Server are you using?

What is actually happening when this login tries to access the other two
databases?


--
Erland Sommarskog, SQL Server MVP, esquel.DeleteThis@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx