Creating A User That Has Full Access To A Database

Hi,

How do I create a user that has full access to a database using only SQL statements?

I've create very basic database called "sampledb".

Then I've done:

CREATE LOGIN sampleuser WITH PASSWORD = '123sampleuser', DEFAULT_DATABASE = sampledb;
USE sampledb;
CREATE sampleuser FOR LOGIN sampleuser WITH DEFAULT_SCHEMA = 'db_owner';

Then I logon to SQL server express 2005 management studio using this user, first of all I do not see the sampledb database listed under "databases" even though it is selected in the "available databases" toolbar (how do I list it there? Because going through "attach..." tells me I do not have the privileges to browse for the database to attach).

I then open up a new query (sampledb is selected), and type (products is one of the table in sampledb):
select * from products;

And I get:


Msg 229, Level 14, State 5, Line 1

The SELECT permission was denied on the object 'Products', database 'sampledb', schema 'dbo'.

Shouldn't the chosen schema (db_owner) give me the right to do this? And how do I fix this from the query window (without going through the GUI, just using SQL statements)? And how do I list sampledb under the databases when I log in as this user?

Thank you!
-Yannick